how to link 2 Combo box

[cindyLiu]

Hello there,

I have 2 Combo box and try to link them:
1. Combo box1, has a dropdown list as: A, B, C;
2. Combo box2, has a dropdown list as: A1, A2, A3, B1, B2, B3, C1, C2, C3;

I try to do this: when I chose A from dropdown list on Combo box1 , then the dropdown list on Combo box2 should only show: A1, A2, and A3.

Please help me!



Thanks,
Cindy

[CJ_London]

what you are referring to is called ''cascading combos'

look to the bottom of this thread where the same question as been asked before. But essentially the rowsource for combo2 should be

SELECT somefield FROM sometable WHERE left(somefield,1)=[combo1]

and in the combo2 gotfocus event put

combo2.requery

You also need to think about these situations

- where combo1 has not been populated
- where user changes the value selected in combo1 after they have selected a value in combo2

[cindyLiu]

Thank you very much, I got it!
Cindy