Microsoft® Access® 2010 Inside Out

Working with Before Events

As we mentioned in the previous section, you can attach data macros to the Before Change, Before Delete, After Insert, After Update, and After Delete events of tables. In the following sections, you’ll learn about the Before Change and Before Delete 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 database.

In Before 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 also 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 ...