Microsoft® Access® 2010 Inside Out

Working with After Events

Access 2010 supports three After events where you can attach data macros. The AfterInsert, AfterUpdate, and AfterDelete events are designed for more extensive operations. In After events, you can use data blocks that take longer to run than the simpler LookupRecord data block available to Before events. For example, in After events, you can iterate over a collection of records, modify other records in other tables, and call named data macros.

After Insert

The After Insert event fires whenever Access completes the operation of committing a new record to a table. In the Back Office Software System sample web database, employee termination records are stored in the tblTerminations table. Whenever a new termination record is ...