Hi guys,
Creating a query in design view, I want to use the value of a particular text box in an open form.
So, I write something like this in the 'Criteria' row of the query design view:
So be it. It works.
Is there any possibility to tell the query to pick up the criteria from the currently open form instead of having to designate it by name?
My point is to be able to use the same query from two different forms, using of course values from text boxes which have the same name.
I hope I explain myself clearly enough...
Creating a query in design view, I want to use the value of a particular text box in an open form.
So, I write something like this in the 'Criteria' row of the query design view:
Code:
[forms]![myForm].[TextBoxName]
So be it. It works.
Is there any possibility to tell the query to pick up the criteria from the currently open form instead of having to designate it by name?
My point is to be able to use the same query from two different forms, using of course values from text boxes which have the same name.
I hope I explain myself clearly enough...