Something like this should work:
UPDATE TableName
SET Field1 = #FORM.Field1#,
Field2 = #FORM.Field2#
WHERE Field1 = #Current value of Field1#
The WHERE clause applies to the existing value. AFTER the update, the value
will reflect the change the user made. To get the current value of Field1,
you can either pass a variable from a query on the form page, or some other
method.
Jesse D. Roberts
Business Process Analyst
Procurement Quality Assurance
Boeing - Huntington Beach, CA
> -----Original Message-----
> From: Miriam Hirschman [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 01, 2000 9:13 AM
> To: CF Forum
> Subject: Update Query
>
> How can I specify which row in my table I want to update if the user has
> the
> ability to change every field. Is there any way besides making an
> autoNumber
> field? I have an Access DB.
>
> Thanks,
>
> ---miriam
>
> --------------------------------------------------------------------------
> ----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
