Update Querry

[Fabian1675]

Hello Everyone;

I have a table called MyTable, a form called MyForm in MyForm there's textbox named Count

What I would to accomplish is to use the Update Query to update one of the entries in MyTable named Total Count from the value entered by the user into the textbox named Count.

Not quite sure how to type the needed syntax in the update query to make this work, can somebody give me a pointer on how to go about this?

Thanks

 

[John Big Booty]

In the Update To: field of the query use;

[Forms]![YourFormName]![YourTextBoxName]

 

[Fabian1675]

In the Update To: field of the query use;

[Forms]![YourFormName]![YourTextBoxName]

Thank you that worked perfectly!