drop down selections (country/state/city)

[fastforded]

wondered how i set up an access db so that users would have a choice on forms for country/state/city where choosing country would make next field they fill in have a drop down menu with choices that only reflects choices made when they choose the previous field?



example: choosing "usa" as country will display next drop down field with 50 choices (1 for each state)

any help appreciated

thanks

[orange]

The topic you are speaking about is called Cascading Comboboxes.

see http://www.datapigtechnologies.com/f...combobox1.html
and http://www.datapigtechnologies.com/f...combobox2.html

These are AC 2003, but the concepts are the same as 2007 and 2010

[fastforded]

The topic you are speaking about is called Cascading Comboboxes.

see http://www.datapigtechnologies.com/f...combobox1.html
and http://www.datapigtechnologies.com/f...combobox2.html

These are AC 2003, but the concepts are the same as 2007 and 2010

yes, thanks, i will try it out, videos looked good

[mike2k]

This is exactly what I'm looking for, except that I can't figure out the code for the 3rd combo box layer

**EDIT
I'm a moron, I figured it out

[fastforded]

The topic you are speaking about is called Cascading Comboboxes.

see http://www.datapigtechnologies.com/f...combobox1.html
and http://www.datapigtechnologies.com/f...combobox2.html

These are AC 2003, but the concepts are the same as 2007 and 2010

i got the first combo box done but cant seem to get the second box to work.. using access 2007 are there any amples ?

thanks

[mike2k]

i got the first combo box done but cant seem to get the second box to work.. using access 2007 are there any amples ?

thanks

The second video is spot on, I didn't have to deviate at all from his example, other than my own data. I'm using Access 2013. Are you receiving an error or just not getting the correct items displayed in the combo box?

[fastforded]

The second video is spot on, I didn't have to deviate at all from his example, other than my own data. I'm using Access 2013. Are you receiving an error or just not getting the correct items displayed in the combo box?

Nothing is displayed in my combo box so I'm not understanding why this isn't listing the drop down choices. It's just blank

[mike2k]

Nothing is displayed in my combo box so I'm not understanding why this isn't listing the drop down choices. It's just blank

Can you zip your DB and attach it, I'll take a look

[mike2k]

Well, I had a really long well detailed reply, but the page refreshed and I lost all of it. I'll try again later

[amrut]

Post you code marking out which part is not working as desired.

[fastforded]

Post you code marking out which part is not working as desired.

i really something up so i just started over but now i cant figure out how to get the fields in new tables to show up, seems like im limited to picking fields from table 1...

dont think i set this up right, any help appreciated

[fastforded]

now it keeps asking me to "enter perimeter value" when i try and test the sql querry?


[forms]![form1].[submodel]

any thoughts appreciated

thanks