Combo box as a parameter query

[RabSwinney]

Help!

How can set up a parameter query, instead of the parameter box coming up asking for the parameter, I can bring up a combo box so the user can pick from a list to run the parameter?

 

[PHV]

Create a parameter form with the combo and a button to launch the query.
The parameter in the query will look like this:
[Forms]![parameter form]![combo name]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886