passing SQL statement to parameter query

M

MSD

I'm trying to pass a SQL statement to the criteria row for a parameter
query. The SQL statement is inside a text box on a form. I am referencing
the form's text box from the query:
[Forms]![myForm]![myTxtBox]

The query returns an empty record set. However, if I type the SQL statement
directly into the criteria cell, the query returns some records.

Thanks so much for the help.

Emma
 
D

Duane Hookom

You would need to modify the SQL property of the saved query to include the
subquery or whatever is stored in your text box.
 
Top