Run report based off combo box selection

[ksdadguy]

I have a form which allows users to generate reports (Preview or Print). My problem is now there will be about 10-15 new reports generated due to three tables added to the db.

Can I use a combo box to have the user select the report they wish to see and then just have two radial buttons to execute either the Preview or Print?

Any help would be appreciated very much.

Thanks,

thedadguy

 

[dhookom]

I create a table of reports that contains fields for the report object name, a title, description, author, ... Then, I use a list box to display the "title" field but bind the list box to the "ObjectName" field. In code you would use something like:
Dim strReport as String
strReport = Me.lboReports
DoCmd.OpenReport strReport,...

Duane
MS Access MVP