The way I do it is with a hidden field that holds the "old" value of the
key:
Example:
Columns One1 Two2 Three3
Value 123 ABC John Doe
<INPUT TYPE="HIDDEN" NAME="Old_One1" VALUE="123">
UPDATE Table
SET One1 = #FORM.One1#,
Two2 = '#FORM.Two2#',
Three3 = '#FORM.Three3#'
WHERE One1 = #FORM.Old_One1#
Works for me,
Dave
----- Original Message -----
From: Miriam Hirschman <[EMAIL PROTECTED]>
To: CF Forum <[EMAIL PROTECTED]>
Sent: Thursday, June 01, 2000 12:13 PM
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=sts&body=sts/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.