help with docmd.openquery

[skoogie]

I wrote a query that select all like items and add the quantity of like items from a user input. Now I want to use a from with a combo box to select the user input. How do I get the info from the combo box to the query. The form has a command button using the DoCmd.OpenQuery and a combo box.

 

[Travis]

In the QBE Grid replace the Criteria with a reference to the form and Combo:

Example:

=Forms![Your Form Name].[Your Combo Box Name]

 

[skoogie]

Thanks Travis that worked .
skoogie