combo box in query

[corpusaggie]

i have a query that allows a user to type in some criteria...but I want to change it so there exists a drop down box in the place of the pop up text box...how can this be done? or can it? thanks for any advice!

 

[Jack Cowley]

Put the combo on a form with a command button to run your query. In the queries Criteria line use code like this:

[Forms]![NameOfForm]![NameOfComboBox]

Have the user make a selection from the combo box and press the command button to run the query....