Save your table with the nametblTestTableMacro. Do not worry about defining a primary
key. This is not required for this example. Click Design in the Access menu and then click
Create Data Macros in the Field, Record, and Table Events group of the ribbon. Click After
Insert.click on the drop-down on the action screen and select Edit Record. You will see a
window like Figure 13-2.166 Microsoft Access 2010 VBA Macro Programming
Figure 13-1 Designing a sample table for a Table Macro