inhibiting select query output

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I run a Select Query called A that goes into a report.
I want to stop the datasheet from the query result appearing on the screen.
Can you help please
 
In your code before or after you open the report, do you have this line

Docmd.OpenQuery "A"

If so, remove it
You don't need to run the query that the report is based on
 
thank you

Ofer Cohen said:
In your code before or after you open the report, do you have this line

Docmd.OpenQuery "A"

If so, remove it
You don't need to run the query that the report is based on
Click to expand...
 

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

Change colour of a field 6
Query Returning Multiple Results 1
Nested or Sub query? 2
Access Query - "Duplicate Records Selected" 5
Use In() Expression as Query criteria with guts from Function 1
Multiple Queries in One Data Sheet.... 1
Union query not displaying select statement 1
query results not showing up in report 4

Back
Top