passing SQL statement to parameter query

  • Thread starter Thread starter MSD
  • Start date Start date
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
 
You would need to modify the SQL property of the saved query to include the
subquery or whatever is stored in your text box.
 
Back
Top