In a subform, I have combo box which depend on a query of course. The query need 2 values from 2 unbound boxes in this subform. I put values into these 2 unbound box before I enter this subform.
This is how I put in the criteria for each field in the query. The control names are: txtContractID and txtContractItem
[forms]![FormName]![txtContractID] and [form]![FormName]![txtContractItem]
Apparently, the query found the controls because it asked for the value for these criteria. I am looking at the value in these 2 boxes insidet the subform and just simply type in the same value when the query asked for them. As soon as I give the values to the query, I get the correct qurey.
My question is how to make the query retrieve the value in the 2 unbound boxes.
I still have problem runnig the query. Change the criteria to the following as the combo box is in the First subform. the query behind the combo box is qureying the 2 unbound box on this First subform.