Drop Down Menu In a Query

[Steve Bremner]

Hi!
When I run a report, I have a basic quesry asking for the search criteria.
But I would rather have the report run off a form with a drop down menu with all relevant search criteria.
But how can I do this?

Make any sense?

Thanks

Steve

 

[neileg]

Create a form. Add a combobox that is based on a query or table that lists all the available options.

In the query that your report is based on, change the criterion entry to point to this combo box, e.g. Forms.frmMyForm.cboMyCombo.

Add a button to the form that runs the report.

That will give you what you want.

Once you get this working, you need to figure out how to ensure that a selection has been made before running the report. That's your homework assignment!

 

[Steve Bremner]

Sounds good enough for me!!

Cheers for the help!

Create a form. Add a combobox that is based on a query or table that lists all the available options.

In the query that your report is based on, change the criterion entry to point to this combo box, e.g. Forms.frmMyForm.cboMyCombo.

Add a button to the form that runs the report.

That will give you what you want.

Once you get this working, you need to figure out how to ensure that a selection has been made before running the report. That's your homework assignment!