From the course: Access 2019: Tips, Tricks, and Techniques
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Cascade the results
From the course: Access 2019: Tips, Tricks, and Techniques
Cascade the results
- [Instructor] 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, on the Customer Data Entry form, we have two Combo Boxes for City and State. Not every combination of City and State are gonna be valid, though. For instance, I don't want somebody to be able to choose Los Angeles, Connecticut. What we need to do is filter the City list based off of a selection from the State list. This is called a Cascading Combo Box, and it's surprisingly easy to set up. Let's go ahead and take this form into Design View. The first thing I need to know is the name of those two Combo Boxes. I'll select the State one and open up the Property Sheet and take a look at the Other tab. Here, we can find that its name is cboState. The city's Combo Box is named cboCity. With those two pieces of information in mind, let's switch over to the Data tab, where we can take a look at the Row Source that'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.