Can you set up a Parameter query that has a drop down list for th.

[Guest]

We are trying to set up a parameter query. The parameter is kind of long
therefore I would like to use a drop down list. What would be the best way
to do this.

 

[Van T. Dinh]

Create a "PreQuery" Form that has a ComboBox so that the user can select the
required (parameter) value and a CommandButton to run the Query. In the
Query, use the reference to the ComboBox as the Parameter.

When the Query is run, it will use the value selected in the ComboBox as the
Parameter value.