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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

optional parameter for query 2
query too complex to pass optional parameters 1
Help in writing SQL statement 2
Pass Through Query - not returning rows 1
Calling Parameterized Query Using SQL Syntax 3
Update Table Field Value with SQL Query 2
How do I execute multiple SQL statements in Access?? 3
iif in the criteria 3

Back
Top