Use a List Box to Filter Records in Access

In this video, I will teach you how to create a list box to filter your customer list based on their state. 

Shannon from Coon Rapids, Minnesota (a Platinum Member) asks: I would like to be able to quickly filter my customer list based on the state they're from. Can you make a simple list box of all of the states so my employees can just click on one and it filters the list? A lot of them are not very computer savvy and I don't want to have to teach them how to right-click, filter, etc. I just want a nice big list box with all of the states we have customers in (there are like 6 of them). 

Members

Members will learn how to create a multi-select list box to pick multiple states.

•  Extended Cut Video - Silver
•  Database 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!

Links

• Query Criteria: https://599cd.com/Criteria
• Aggregate Queries: https://599cd.com/Aggregate
• Intro VBA: https://599cd.com/IntroVBA
• Double Double Quotes: https://599cd.com/Double
• Concatenation: https://599cd.com/Concat
• Access Developer 15: https://599cd.com/ACD15

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 Diamond Sponsors - Information on our Sponsors 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.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, How to Filter on a List box, multi-select list box, ListBox.MultiSelect property, Use a multi-select list box, Storing Multiple Selections From A List Box, multiselect, Microsoft Access Multi Select List Box, Using a Listbox on a form to filter, list box for criteria