I am trying to create a query which takes the criteria from a textbox in a form, which itself has been filtered.
I have a button on the form with runs the query, which should display all dates for ther person shown in the textbox on the form.
I have tried useing:
=[textbox]
and:
[form]!formname]![textbox]
and:
[me]![textbox]
where formname is the name of the form and textbox is the name of the textbox.
but it when I run the query it just comes up asking what i want [form]!formname]![textbox] contains.
How do you get it so that the query will use the textbox on the form as the criteria?
is always in the details.
