14. Working with Reports

Introducing the Report Module and Events

For the most part, VBA code is stored in one of two module types: standard or object. The object module is a special module attached to a report or a form. The module is saved with the object and supports events and properties that are unique to the object.

Most of the code you enter and store in a report module (or a form module for that matter) comes in the form of event procedures—code that’s executed when some action occurs. For instance, code added to the report’s ...

Get Business solutions Automating Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.