How to Run a Macro from a Navigation Button in Microsoft Access

See Microsoft Access: Tips and Tricks for similar articles.
Looking to improve your Microsoft Access skills? Check out Webucator’s Microsoft Access classes.

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.

Related Articles

  1. How to Create a Form with the Form Wizard in Microsoft Access
  2. How to Create a Report with the Report Wizard in Microsoft Access
  3. How to Add a Header and Footer to a Form in Microsoft Access
  4. How to Add a Header and Footer to a Report in Microsoft Access
  5. How to Open a Table in Design View in Microsoft Access
  6. How to Rename a Table in Microsoft Access
  7. How to Move a Field in the Query Grid in Microsoft Access
  8. How to Create a Navigation Form in Microsoft Access
  9. How to Add a Logo to a Form Header in Microsoft Access
  10. How to Add a Title to a Form Header in Microsoft Access
  11. How to Set the Navigation Form as the Default Form in Microsoft Access
  12. How to Run a Macro from a Navigation Button in Microsoft Access (this article)
  13. How to Add a Title to a Report Header in Microsoft Access
  14. How to Add a Logo to a Report Header in Microsoft Access