How to Use a List Box to Filter Records in Microsoft Access (Extended Cut: Multi-Select Listbox)

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).

Silver Members and up get access to an Extended Cut of this video. Members will learn how to create a multi-select list box to pick multiple states.

MEMBERS VIDEO:
https://youtu.be/QYW_ycsTEw4

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

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

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

COURSES:
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:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

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

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

Видео How to Use a List Box to Filter Records in Microsoft Access (Extended Cut: Multi-Select Listbox) канала Computer Learning Zone