Use a List Box or Combo Box to Display Specific Reports to Print in your Microsoft Access Database

Learn how to make a listbox that's got all of the reports you need to print on a regular basis. All your users have to do is click on a report and then click on a "print" button, and voila. There's your report. Nice and easy to maintain and update, too.

Avery from Mesa, Arizona (a Gold Member) asks: Is there a way I can create a list box or a combo box that displays a list of the available reports in my database. I don't need all of them, just a handful. I'd like to make it easy for the users to pick one and click a button to print it. I also don't want to have to add buttons to a menu every time I make a new report (which is often). Help?

BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. I'll show you how to do the same thing without having to maintain a table. We'll loop through the Reports collection in VBA and use that to populate the list. I'll show you how to add a Description property attribute to a report for the display text. Fun stuff!

MEMBERS VIDEO:
   • Use a List Box or Combo Box to Displa...  

BECOME A MEMBER:
   / @599cd  

LEARN MORE:
https://599cd.com/ReportListbox

WHAT COURSE:
This isn't covered in any of my courses! New stuff!

LINKS:
Relational Combo Box: https://599cd.com/RelationalCombo
Intro to VBA: https://599cd.com/IntroVBA
ListBox.AddItem: https://599cd.com/ACD16

LEARN MORE:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/Consulting
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: [email protected]

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, selecting a report from a listbox, report combo box, listbox of available reports, report drop down list, AccessObject, Application.CurrentProject.AllReports, Containers, Documents, CurrentDB

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.