Open "Macros" tab after module is run

  • Thread starter Thread starter MikeM
  • Start date Start date
M

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
 
-----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


.
Click to expand...


Just use:

DoCmd.SelectObject acMacro,,True
 
Back
Top