Combo box value from two different table

[johnyjassi]

Hi guys,

I am working on two combo boxes, If we select values from combo1 it should show value in combo2. Here is the twist...
Lets say combo1 has value A and B, if we select A from combo1 it should return value from table1 and show in combo2. If we select B, it should show value from table2 in combo2.Any help will be appreciated.

Thanks

 

[ajetrumpet]

this is not usually done. Just thinking about it, I would say that your tables might need to be restructured. However, you can populate combo box 2 on a conditional basis, but you need to know the criteria. I'm sure there are more than 2 values in the combo box A, so you need the criteria first before you can write the code to do this...

It is probably not just if(combo A = 'A', value 1, value2)