Microsoft® Access® 2010 Inside Out

Summary of Form and Report Events

Access provides more than 60 different events on forms, form controls, and reports that can trigger macros or Visual Basic procedures. You indicate that you want to respond to an event by providing the name of a macro, a Visual Basic function (preceded by an equals sign), or the special settings [Event Procedure] or [Embedded Macro] as the setting of the event property in the Property Sheet window. When you specify [Event Procedure], Access looks for a Visual Basic procedure in the module stored with the form or report that has the name of the event. When the event property is set to [Embedded Macro], Access executes the related macro embedded in the form or report definition. For details about Visual Basic procedures, ...