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.

  1. Open the navigation form in Layout view.

  2. In the button area, right-click and select Insert Navigation Button from the shortcut menu. A new navigation button is added.
    Select Insert Navigation Button

  3. 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.
    Type Label for Button

  4. Select the Event tab.

  5. In the On Click field, select the macro you want to run from the drop-down list or click the points of ellipsis
    Select Macro to build a macro.
    Navigation Form

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

About Webucator

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Check out our complete course catalog.