Open the invisble query

[accessman2]

Hi,

I have a question.

In VBA, can we select the object, query, and then open it as invisble status and then close it?

I just know that

Docmd.openquery "qry1"
docmd.Close acQuery,"qry1"

But, I want to make it in the invisible status, nobody read it on the screen.

Can we do that?

Thanks.

 

[KeithG]

Sure, something like below should work.


Dim myRec as DAO.Recordset


Set myRec=currentDb.openrecordset("qry1")