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

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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