From the course: Access 2016: Advanced Tips and Tricks
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Cascade the results
From the course: Access 2016: Advanced Tips and Tricks
Cascade the results
- [Voiceover] One of the questions that I get all the time is how to create a combo box that only shows options based off of a selection in another combo box. For instance, here in our customer data entry form we have combo boxes for city and state. Now, not every combination of city and state are valid. For instance, I wouldn't want somebody to be able to choose Los Angeles, Connecticut. What we need to do is filter the city list based off of selection made in the state combo box. This is called a cascading combo box and it's surprisingly easy to set up. First, all we need to do is switch our form here into design view. Then, I need to verify the names of these two combo boxes. So, let's go ahead and open up the property sheet and switch over to the other tab. Then, I'll click on this city combo box here and we can see it's name is CBOCity. I'll click on the state combo box and it's name is CBOState. Then, I just need to edit the query that drives this city combo box here. So, let's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.