Drop Down Boxes

P

Paul

Hi,

Help!! I will try to explain this so it makes sense, I hope.

I have a form and on it are 2 drop down boxes, and basically what I need to
do is when I select an option from the first drop down box I then need that
to filter the second drop down box based on the first drop down box
selection??

Hope this makes sense, if not let me know and I will try and explain.

Paul
 
A

Alex Dybenko

while making a rowsource query for combo2 - use combo1 value in criteria,
and in Combo1 afterupdate event run Combo2.Requery to update it rowsouce
after selection in Combo1 was done
 
P

Paul

Alex,

Thanks for your response Alex.

You will have to explain what you mean in more detail for me, i.e. a step by
step process. Sorry to be a pain but I am a relatively new user to Access.

Thanks

Paul
 
A

Alex Dybenko

so you have a Form1 with Combo1 and Combo2
in Combo1 you have have a list of countries
in combo2 you want to list orders for selected country
so in Combo2 rowsource you have a following query:

Select OrderID, OrderNum from Orders Where OrderCountry=Forms!Form1!Combo1

and finally you go to Combo1 AfterUpdate event event proc, adn write there:

Me.Combo2.Requery

HTH
 
Top