Creating Reports from drop down boxes

[redcare]

I am working on an Access 2000 database that involves creating reports.
Iam trying to use a combobox to choose the reports that I would like to access.
I would be grateful for any suggestions ?????

 

[randysmid]

Hi,
I do this as well, and have some interesting techniques.
First, I created a new table in the database which contains the names of the reports I want to display in a combobox.
Second, on the form to be used to create the reports, I added a combobox with the new table as the Row Source.
Third, some of my reports use different criteria. So, on the &quot;After Update&quot; event, I use code to check the report name that was selected. Then I set the necessary text boxes on the report for Visible=True (e.g., lstCounty.Visible = True <--- if county is required to generate the report)
Fourth, I use queries to generate the data needed for the report, and base the report recordsource on this particular query. When I then run the report, I like to pass the values selected by the user as a &quot;filter&quot;. (I wrote an FAQ on this topic - see faq703-2657 under Access Reports).

HTH,
Randy Smith
California Teachers Association