Microsoft® Access® 2010 Inside Out

Calling Named Data Macros

As you learned in Chapter 7, Access 2010 now includes data macros that you can use to attach logic at the data layer. When you attach data macros to table events, Access only fires those data macros in response to data events, such as inserting a new record, updating values in an existing record, or deleting records. You can also create a named data macro attached to the table itself. A named data macro, in many ways, is similar to a public procedure or function in a standard code module—you can call a named data macro from macros and Visual Basic to execute the actions defined in the data macro and return results to the caller if you want.

In the Back Office Software System web database, we defined many named data macros ...