When you run a macro, Microsoft Access starts at the beginning of the macro and carries out all the actions in the macro until it reaches either another macro (if the macro is in a macro group) or the end of the macro.
You can run a macro directly, from another macro or an event procedure, or in response to an event that occurs on a form or report, or a control on a form or report. For example, you can attach a macro to a command button on a form so that the macro runs when a user clicks the button. You can also create a custom menu command or toolbar button that runs a macro, assign a macro to a key combination, or run a macro automatically when you open a database.
Run a macro from another macro or an event procedure
Run a macro in response to an event on a form, report, or control
Create a command button that runs a macro
Add a menu command that runs a macro
Add a toolbar button that runs a macro
Assign a macro to a key combination
Run a macro when my database first opens