How Can I Repopulate an Access 2010 Combo Box when the Value of Another Box Changes?

I have a database with 5 tables, but most of the tables are to ensure that fields in the 5th table can only have certain values.  I have one table that contains the values for 'type' and another one that holds the values for 'subtype' and associates them with 'types' via a relationship.

In the form for entering data into the 5th table, I have a combo box that contains all the types pulled from the types table.  

What I want to achieve is to have a second combo box that updates every time the first combo box is changed.  In other words, when the user selects a 'type', I want the 'subtypes' of that 'type' only to appear in the second combo box.

I can't seem to work out how to do this though, so suggestions would be greatly appreciated!

Thanks in advance,

Who is Participating?
Rey Obrero (Capricorn1)Commented:
combo boxes used RowSource to display the choices available

see this links

How to synchronize two combo boxes on a form
There are a few ways to do this. You can set 'Sub-types' combo boxes record source as a query dependent on the First Combo Box. Provided they share a relationship i.e. SubType field has a MainTypeID or some other link.

Hope that helps.

williamzNetAuthor Commented:
Thanks to both, the top link in Capricorn1's solution had a walk through which worked perfectly.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.