Microsoft Access 2013 Inside Out

Working with table events

As I mentioned in the previous section, you can attach data macros to the On Insert, On Update, and On Delete table events. In the following sections, you’ll learn about each of these events, create new data macros attached to events, and examine other data macros attached to these events in the Back Office Software System sample web app.

In On Insert and On Update events, you can look at the incoming values in the current record and compare them with a record in other tables using the LookupRecord data block. You can use the SetField data action to alter data before Access commits the changes but only on the incoming row of data, not on a record returned from the LookupRecord data block. In all table events, you can prevent ...