Microsoft Access Cascading Combo Boxes - One Combo Box Selection Filters a Second Combo Box

In this video, I will show you how to set up cascading combo boxes. This is where the value selected in the first combo box will filter the results of the second combo box. For example, you choose a state in box one, and then box two will show only a list of cities from that state.

Liana from Honolulu, Hawaii (a Platinum Member) asks: When I'm entering in my customer's address, is there any way that I can pick the state first from a list of options, and then have the city combo box only show cities from that state? I have a very select list of city/state combinations that my company sells to, and it would be so much easier than typing these in every time. Thanks!

Silver Members and up get access to an Extended Cut of this video. Members will learn how to display cascading combo boxes in a continuous form, and also how to perform the cascade without the need of an external query.

MEMBERS VIDEO:
   • Microsoft Access Cascading Combo Boxe...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

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

LINKS:
Relationships: https://599cd.com/Relationships
Relational Combo Boxes: https://599cd.com/RelationalCombo
Get Criteria from Open Form: https://599cd.com/CriteriaForm
Intro to VBA: https://599cd.com/IntroVBA
AfterUpdate Event: https://599cd.com/AfterUpdate
OnCurrent Event: https://599cd.com/OnCurrent
Zip Code Template: https://599cd.com/ZIPCode
Subforms: https://599cd.com/Subform
Access Beginner 8: https://599cd.com/ACB8

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:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, cascading combo boxes, city state select, link combo boxes, dependent on another combobox, multiple cascading combo boxes, cascading combo boxes in continuous forms, cascading combo boxes subform, choose from list of cities in state, afterupdate, me.requery, oncurrent, List Items Edit Form, synchronize two combo boxes

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