Update Query

[Guest]

I have created a update query, trying to subtract ordered from units on hand.
Every time the query is ran it pops up wanting parameter values instead of
taking it from the form. When I enter the data in the parameter values the
query operates correctly. How do I make the query take information from the
form???? I am so lost any help would be appreciated...

 

[SusanV]

In the query's criteria, put
Forms!YourForm.YourControl

 

[Guest]

Place your cursor In the criteria area of the field of your query where the
criteria is needed and right click. Select the Build option. In the
Expression Builder double click on the forms option. Locate your form. The
list of controls in the selected form will be presented in the center box.
Select the control that will hold the value you want as your criteria for the
query and click the Paste button. Then Close the Expression Builder and Save
your query.