Combobox with list of reports to print

[robertm600635]

I would like to create a combobox with a list of reports and have a "Print"
command button underneath it so I can select a report from the list then
print it. I have quite a few reports set up and don't want to create a
command button for each of them. Any way to do this?

 

[Jeff Boyce]

Since I use a naming convention on my Access objects, the "Access" report
name may be a bit confusing to the user. I create a new table, in which I
list the Access object name, a user-friendly name, a description, and any
other incidental values, then display the user-friendly names in a combo box
on a form.

The <Print Preview> button (not a bad idea, rather than straight to print)
uses the hidden (width = 0) column with the Access object name and the
DoCmd.OpenReport expression to open the selected report.

When I have a large number of reports, I categorize them, add a
tlkpReportCategory table to keep the categories, add a ReportCategory
(foreign key) field in the tblReports table, and use a "Select Category"
combo box to prefilter the contents of the "Available Reports" combo box.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/