O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required