combo box to select criteria for report

[corpusaggie]

ok - I have a report that is based on a query, which asks to specify criteria before creating it. I want to make this process as user friendly as possible, so instead of the text box popping up at the beginning before the report is created, I would like a drop down box to pop up so the user can just select the specific criteria, instead of typing it...can this be done? Please help, if you can. Many thanks to anyone who has some advice.

 

[Idjit]

What I usually do is create a form to do this. Put the combo box on the form as an unbound field, and include this field as the selection criteria in the query that generates the report. So the user will open the form frmReport, select a value in the combo box NAME, then click on a command button that runs the report.

In the query design, specify the unbound combo box as the criteria for the field you're using to select records: [Forms]![frmReport]![NAME]

As long as your user launches the report from the form, this should work fine. If you run the query or report from the database window you'll still get the 'enter parameter value' windows.