Originally Posted by
Ajax
it is if the control can be referenced in that way. For example a combobox on a form can use something like this in its rowsource (as opposed to the name of a query)
SELECT * FROM myTable WHERE stage Like [StageTxt] & "*"
A query is a separate object, so you have to provide the reference 'path' - i.e.'use the named control in the forms collection in this form'. So I am mystified how you could get it to work in a query without using the 'path'.
Perhaps upload an example of the forms with some basic test data to illustrate what you mean. It may be we are all talking at cross purposes.