Closing Query in Macro

  • Thread starter Thread starter Gerrym
  • Start date Start date
G

Gerrym

I have a Macro which opens four queries, when it is
finished it leaves the last query open on screen. I would
like it to close the last query and return to the access
screen (the screen from where I run the macro)
Can anyone advise pls.
 
Gerry,

It is difficult to imagine what you are doing. Generally the only
reason to "open" a query in a macro is if it is an Action Query (e.g.
Append, Update). But is sounds like yours is a Select Query if you end
up with a query datasheet displayed. So, what is the purpose of opening
the query in the macro. To me, either you want it open so you can "do"
something with it, in which case you wouldn't want it to close. Or else
you don't want it open, so therefore why open it in the first place?
 
Back
Top