How To Run a Query?

[Coffee]

Hello,

is there a way i can Run my "SELECT" SQL query on my forum without having the Results (datasheet) view opening up over my form?

i have already tried

DoCmd.SetWarnings False
DoCmd.OpenQuery "query"


DoCmd.SetWarnings True

AND

Form.Echo = False
DoCmd.OpenQuery "query"
Form.Echo = True

AND

Application.Echo = False
DoCmd.OpenQuery "query"
Application.Echo = True

[Access_Blaster]

Would Minimize help? or Close.

DoCmd.OpenQuery "query"
DoCmd.Minimize

What is the reason for running the query?

[Coffee]

all the SQL is in VBA and loads into a empty query statement under query and the last search is stored there. so if you open the query as a report it will display the last report. because you need to run it first to update the report file to show correct results in report

[Coffee]

can you make it so it doesnt pop up at all?. cos even

DoCmd.Close acQuery, "query"

makes it flash up and looks tacky