Parameter Query

[woodywoodpecker]

Is there a way to make the pop-up window for a parameter query a drop-down field that contains the options a user could select? I have a parameter query that feeds a report. The parameter instructs the user to input the "project" they want to see data for. I would like to have a drop-down that contains all the "projects" instead of having the user just type it in. Thanks.

 

[RivetHed]

The easiest way you could do this would be to have a form to enter the details into rather than a parameter query.
Create a form with a combobox containing all the options and set the query criteria to [forms]![FormName]![ComboBox1]
then have a command button on the form to run the query!

This also looks a lot prettier!