Can a query run and not be visible?

[Gkirkup]

I have an email program that sends several emails, each one requiring a query. But the query is visible as the email is sent, and has to be closed manually. Is there a way to run the query without it being visible? I am using OpenQuery.

Alternatively, is there a way to close an open query to remove it from the screen?

Robert

 

[Galaxiom]

Open a recordset instead.
However you will need to change the code to use the recordset. Without knowing what it does now it would be hard to advise further.