Update query from user input

[MJB3K]

I would like to know how to update a field in access that includes a figure input by the end user.

I know how to use an update query, but don't know how to add a figure input from the end user.


Regards,

Martin

Computing Design And Services:

http://www.webrevolt.biz

 

[PHV]

Sorry to ask but I'm not a native english speaker:
what is a figure input ?

 

[lespaul]

you mean you want the user to enter the value to be set? I don't think this will work, but this is kinda what you are asking for, right?

UPDATE TableName SET FieldName = [Enter new value]

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins