Using MS Access/Access Reports


I have a database that requires to print many reports based on multiple and different queries. What is the best practice to print these reports. Is it to create a command button to each one or one button with "If" conditions? or you suggest another tip?
Thank you.

The best practice is to create a form with dropdown boxes where you can select the report and click a button to print the selected report.

You can create a table with the names of the reports, and have the dropdown box use this table for the list of the reports. Make the command button to open the selected report.

If you have just a couple of reports, you can use IIF clause function, else you can use VBA to open the selected report.

Hope this helps.
Mark Kaphle

Using MS Access

All Answers

Answers by Expert:

Ask Experts


Mark Kaphle


I can answer most questions on database design using Access. I can help with VBA too. I can integrate engineering and business needs in the database design.


I have more than 15 years of MS Access database design experience.

College degree in engineering. Graduate degrees in engineering and management. Current PHD student - concentration Industrial Engineering.

©2017 All rights reserved.