query based on combo box

[simo7923]

I have 2 combo boxes. 1 relating to a table with 4 fields (desk) and the other relating to a table with 2 columns (desk and system). I would like the 2nd combo box to only show data depending on what is in the 1st. I would be able to do this if i could make a query which would include combo box 1. eg if combo box 1 = field1 then combo box 2 will only show records containing related to the data in field 1. Its difficult to explain. Basically can i make a query and specify a combo box in it

 

[dcx693]

Yes, you can make a query and reference the value in a combo box from it. The combo box setup you are describing is often referred to as "cascading" combo boxes. I suggest you do a search of the forums for tips and examples.

 

[simo7923]

thanks....will do......would have searched before but i didnt know what to search for........what a forum!!!