Chapter 14. Working with Reports

IN THIS CHAPTER

An introduction to the Report Module and Events 187

Opening and Closing Reports 188

Passing Arguments Using OpenArgs 190

Populating the Report 191

Handling Report-Level Errors 194

Working with Subreports 195

Case Study: Product Catalog 196

An Introduction to the Report Module and Events

As discussed previously, your VBA code can be stored in either a standard or object module. Most of your code will be in object modules attached to a form or report. The code is saved as part of the object and supports events and properties specific to that object.

Almost all the code that you write for an object module is placed within event procedures to be triggered when some action occurs. For example, if you ...

Get Microsoft® Office Access 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.