Combo selection for reports

[AdamO]

I have over 40 reports which users will select. Currently they have separate command buttons on a form. There are too many reports now and it looks very untidy.
I considered building a combo on a new from which had as selections all of the report names. I manually added these name into the list (arrrgh!) and completed the combo. My intention was to place a Preview Report button next to this combo to run the selected report. Unfortunately, this only enables me to select one report.
Is there any way of overcoming this, or is there a better way of tidying report selection. Ideally, the reports fall into three areas and it would be good to select the area and then have those reports within that area shown as the combo items. I have seen something on Northwind but I have not been successful in transfering this to my database.
I am a quite new to Access with no VB experience. I suspect I will need to get my feet wet here now. Please bear this in mind with any replies.
Any guidance would be very much appreciated. Thank you.

 

[wizcow]

Your list of reports should live in a table. The table would have three columns; ReportID,
Report Catagory, and Report Name.
Your combo box should run from a query that accesses that table.
If you have three catagorys for reports, add three radio buttons on your 'Report Selection Form'.
Have the query that runs your combo box look up which radio button is selected. Your query can short list your combo box selections.
Add three buttons on your 'Report Selection Form'; Close, Print and Print Preview.
Have your print button look up the combo box and go directly to print.
Have the print preview look up the combo box and preveiw your report.

It sounded like you may want to preview all of your forms from one command. If that is so, I don't know if you can.

Hope that helps
Tom