Lookup Combo Problem.. NEED HELP!!!

[eoceguera]

hi there guys.. i need your help...

this is what im trying to do.

i have a lookup combobox.. that's feeding of a query..
and i need a second lookup combobox that depending on the selection of combobox1 is the items that it will have..

i'm really stuck with this any ideas??

here's an example..

query 1
A 1
A 2
A 3
B 5
B 6

combobox1 has a query that displays only A and B and if I select A I want combobox2 to display 1,2 and 3

thanks..

 

[nickjar2]

Hi,

In the query for comboBox2 you will need to include the comboBox1 as the criteria. On the lines of:

forms!formName!comboBox1 Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[eoceguera]

HEY nICK.. thanks for your answer.. I actually followed..
faq702-681 and that solved my problem pretty good..

thanks again for your reply..