corpusaggie
04-30-2002, 01:44 PM
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!
|
View Full Version : combo box in query corpusaggie 04-30-2002, 01:44 PM 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 04-30-2002, 05:53 PM 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.... |