Change sub dropdown based on main dropdown in access forms

[patelniravd]

Hi,

I am a newbie in Microsoft access. I made a access form which has 2
dropdown list box namely dropdown1 and dropdown2. I want to populate
dropdown2 based on value user selected on dropdown1. basically,
dropdown2 I want to populate from a table from the same database based
on value selected in dropdown1.

Can I get some code snippet or some hint so I can write such code.

Thank you,
Nirav

 

[tina]

see http://www.mvps.org/access/forms/frm0028.htm for one solution. btw, the
correct name for a "dropdown list box" is "combo box".

hth

 

[patelniravd]

Thanks for our quick reply and it worked it too.

Now I am again facing a small problem and that is
I would like to upate textbox based on combobox1. combox1 rowsource
displays 3 columns - customer name, id and address. when I select any
customer from there, I want to copy address from the selected row to a
text box in the same form. How can I do that?

Thank you,
Nirav