Hiding the query display

[aurosunil]

I am trying to generate a report based on two tables and a query based on these two tables.
When I preview the report this query is also run and result is shown.
There is no need of displaying the query results, can it be done?
can any one help?

sunil

 

[BoroLee]

Is your report based on the tables, or a query????

 

[Pat Hartman]

You must have code that opens the query. Get rid of it. The report runs the query when it opens. You don't need to do it also.

 

[aurosunil]

Report is based on three tables and a querry based on two tables. I have not written any code. there is nothing in the code window.
sunil

 

[Pat Hartman]

Queries don't just open by them selves. Are you running a macro that opens the query?

 

[aurosunil]

Dear Bridge Player,

Yes, there was a statement in the code for the button used for opening the report which i put there while i trying some other way for the report. when i removed that it worked.
Thank you very much for the help.

sunil