O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

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

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