Drop Down Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
Back
Top