Open "Macros" tab after module is run

[MikeM]

I have created a module that runs great. I have the use run it from a macro
that is using RunCode. In the module I create a table by running
DoCmd.OpenQuery "qmakOnHand"
After the code is finished running it stops on the table that was just
created. How can I select the "Macros" tab using code?

MikeM

 

[Guest]

-----Original Message-----
I have created a module that runs great. I have the use run it from a macro
that is using RunCode. In the module I create a table by running
DoCmd.OpenQuery "qmakOnHand"
After the code is finished running it stops on the table that was just
created. How can I select the "Macros" tab using code?

MikeM


.

Just use:

DoCmd.SelectObject acMacro,,True