Selection list in form. Values from a table depend on selection from different table

[JoeyJoystick]

Hi All,

Situation: 3 tables. Manufacturers, Countries & Provinces/States. 1 Form for data entry in Manufacturers.

Countries table contains ID, Country and CountryCode fields. i.e. 47, Great Britain & GB

Provinces/States table contains ID, Province/State and CountryCode. as in 1, Alaska and US.

In the form the country is easily selected from a list refering directly to the Countries table.

Problem: How to make a list in the form from which the user can simply select the province for the country that has previously been selected. And not a list with all teh provinces and states from every country in the world. (This would be a really really long list...)

With my lack of experience it is ofcourse very possible that I have taken the wrong approach, in this case some guidance in the right direction will do for now, but I have no idea how to solve the above issue at hand. Some help is appreciated.

Joost (Joey)

 

[spikepl]

This is called "cascading combos" or "cascading comboboxes" search/google for that

 

[JoeyJoystick]

Thanks a lot for the tip Spike! Will let you know how it goes later.

 

[JoeyJoystick]

Solved!

Not all that easy for a novice, but most lost time was only because I made it harder on myself than I should have.

Thank you very much for the help Spike. Link to below video was the best I found. maybe of help to others.

Ok, I am too new to place links I see, so here the title of the video in YouTube.

Microsoft Access pt 9 (Cascade Combo Box)

By: Amir Parmar.

I see many posts that show SOLVED in front of the thread. How can I do this? Just wanna make sure I do it right.

Joost (Joey)