On Thu, 29 Nov 2007 13:05:30 -0800 (PST), Sheldon wrote:
How can this be done and what is the syntax?
Thanks,
Sheldon Potolsky
The table has one record? O.K.
The field you wish to give a value to is what datatype?
And the value you wish to enter is what?
CurrentDb.Execute "Update YourTable Set YourTable.[FieldName] =
'What?';", dbFailOnError
Now if you had spent a bit more time on your message and given more
particulars, I could have given you the correct syntax for the
datatype of the field you wish to update, as it is different for
Number, Text, and Date datatypes.
As it is, the syntax is correct for a Text datatype field.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail