How to Run a Macro from a Navigation Button in Microsoft Access
You're not limited to running forms and reports from the navigation form. You can use navigation buttons to run macros as well, thus opening the range of functionality to any process you can write a macro or module for.
This feature works the same in all modern versions of Microsoft Access: 2010, 2013, and 2016.
- Open the navigation form in Layout view.
- In the button area, right-click and select Insert Navigation Button from the shortcut menu. A new navigation button is added.
- With the new navigation button selected, go to the Property Sheet and on the Format tab in the Caption field, type a label for the button.
- Select the Event tab.
- In the On Click field, select the macro you want to run from the drop-down list or click the points of ellipsis
to build a macro.
- Preview the navigation form in Form view and click the new button to test the macro.
Author: Tracy Berry
Tracy has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide, including involvement in large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, reporting/productivity applications, as well as the creation of online courses with software from leading vendors.