Join Adam Wilbert for an in-depth discussion in this video Trigger submacros with buttons, part of Access 2019: Macros.
- [Instructor] Now if I were just to simply double-click…on the export macro, it's only going to run…the first sub-macro, this January portion of the macro.…Instead, what I need to do is provide buttons…that'll link directly to each sub-macro inside…of the export macro.…I'll go ahead a close the macro down.…That'll return us to the main menu form,…and I'll take that into design view.…Then, on the design tab, I'll grab a button control object,…and we'll come down to the bottom,…and actually going to scroll down a little bit,…and we'll click down here at the very bottom…to add a new button in.…I'm not going to use the command button wizard,…so I'll press the cancel button.…
Then I'll double-click on the button…to just rename it to just simply Jan.…And I'll resize it just a little bit to make it smaller.…Next I'm going to open up the property sheet for this,…and take a look at the event tab of the property sheet.…And, if I expand the drop down menu on the On Click event,…you'll see how these sub-macros will display.…
- Creating multi-step macros
- Triggering macros
- Running macros at startup
- Adjusting the execution and flow of macros
- Troubleshooting macros