Hiding query

[vandenherik]

All,
I have a report that displays the results of a query. The query and the report are both run from a submit button on a form. I use DoCmd.OpenQuery "name", followed by DoCmd.OpenReport "name". Due to slow network connection the query shows up before the form is displayed. I would like the query to be hidden or minimised. In other words, I do not want the user to see the results of the query, only the report.
Thanks,
Dirk

 

[gemma-the-husky]

why open the query?

this is nothing to do with speed, I don't think.

if you ask for the query results, THEN the report, the report will not open until the query is completed.

 

[vandenherik]

Dave,
Thanks for your reply. The reason for opening the query is to get the value in the report. If I don`t open the query, the form will be empty.
Regards,
Dirk

 

[vandenherik]

Dave,
I made a mistake. The report does show the queries content after removing the code to open the query. Thanks again.
Dirk