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 Display Spe...   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: amicron@gmail.com 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.