Using the On Double Click Event. Open Record.

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?

Members

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!

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

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 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.