How to Create Event Procedures MS Access

Quick summary

Event procedures in MS Access let you run VBA code automatically when a user interacts with a form or report. You can create and attach event procedures directly from the Property Sheet in Design View without writing code from scratch.

Steps

1. Open your database in Microsoft Access.
2. Go to the Forms or Reports section in the Navigation Pane, right-click the form or report, and choose Design View.
3. Click the Property Sheet button in the ribbon to open the property panel.
4. In the Property Sheet, navigate to the Event tab.
5. Find the event you want to use and click the ellipsis icon to create an event procedure.
6. In the VBA editor, write your event procedure code and save the module.
7. Click the save icon to save all changes to your form or report.