combo box problems 2

[Johnny0123]

hi,

i have a combo box with a job # then the second combo box is a sequence # related to job #. Finally after the job # and the sequence # are picked two other text boxes are filled with the information linked to their fields. The problem is i can not get it to work. Help!

Thanks,

John

 

[PHV]

The problem is i can not get it to work
The problem for us is that we have no clue about what you have tried.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Johnny0123]

sorry PHV,

i tried to make a query that is the Row Source in my combobox that has the fields that i need to link to the text boxes. As far as the code goes, i have no idea where to start.

Thanks
John

 

[randy700]

Create your combo box as though it had no dependency on the other combo box. Then, add a WHERE clause to the row source.

WHERE ID = [OtherComboBoxName]


Randy

 

[Johnny0123]

thank you guys!! I got it...

-John