Microsoft Office Tutorials and References
In Depth Information
Attaching Macros to Tables
Book VI
Chapter 2
Figure 2-1:
A table
in Design
view, ready
for data
macros.
2. Click the Create Data Macros button in the Field, Record & Table
Events group on the Design tab of the Ribbon.
You see a list of the events that can trigger a data macro, as listed in
Table 2-1. When a user, a macro, or a VBA module performs one of these
actions on this field, the macro runs.
Table 2-1
Data Macro Events
Event
Description
After Insert
After a new record has been added to this table
After Update
After any field in a record in this table has been
updated
After Delete
After a record in this table has been deleted
Before Delete
When a record in this table is about to be deleted
Before Change
When a record in this table is about to be updated
Create Named Macro
When you create a new macro and give it a name
When you edit a named macro
Edit Named Macro
Search JabSto ::




Custom Search