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,

Dave
williamzNetAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

OCDanCommented:
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.

0
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
http://support.microsoft.com/?kbid=289670

http://www.fontstuff.com/access/acctut10.htm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
williamzNetAuthor Commented:
Thanks to both, the top link in Capricorn1's solution had a walk through which worked perfectly.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.