Filtered Combo Boxes
Updating the records in one combo box based on the value selected in another.
Q: I have two combo boxes on my form. When the user
selects a value in Combo Box One, I need to filter the list in Combo Box
Two. For example, if the first combo box has a list of States, then I
want Combo Box Two to show only cities from the state chosen in Combo
Box One.
A: I get asked this question
all the time. This is NOT easy to do, but it can be done. You
need to know how to
make a combo box, how to
get a query
critiera from a form field, and how to
create an AfterUpdate event.
Once you've mastered those techniques, you're ready to move on to this
lesson.
Here is a FREE VIDEO TUTORIAL
that will walk you through an example of working with multiple combo
boxes. It's
much easier to show you how it's done than to explain it here.
I teach the concepts in this free mini tutorial in my
Access 307 course. These are
full courses - over 60 minutes in length each. I spend a lot more time going
over how to do this, in addition to lots more tips and tricks.
| 
