Update Query with Variable

[lfast]

When you use something in this format:

[Enter new description]

I want to save the input into a variable, and then use that
variable in an update query.

How do I do it?

-- Thank you!

David Brook

 

[WildHare]

Put [ENTER NEW DESCRIPTION] in the Update TO line of the query..you'll get prompted for it. There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm