inhibiting select query output

[simcon]

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

 

[Ofer Cohen]

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

 

[simcon]

thank you

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