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

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