Report using a combo box

[amey76]

I am using an exisiting database that is based on one table and lots of queries. I am trying to generate a report based on one field (Named Day 1) which has about 300 records already but is only 5 dates. (but these are not generated from a look up table)

I would like to run a report that lists all of the records for one of these dates without using the open parameter box but a drop down box that displays only these 5 dates for them to choose and then generates the report.

I hope this makes sense. I am not that VB literate so dummy instructions would be greatly appreciated.
Thanks

 

[burrcm]

The combo would be on a form. You would create a new query which looks up the dates only and groups them (one of each only). Use this query as the row source for the combo. The reports query would reference this combo as its criteria. Add a button to the form which runs the report. In the reports on open, close the form.

Chris B