Access 2002 Programming by Example

The On Open Event

In reports, this event occurs before a report is previewed or printed. It is the first event to be activated, giving you an opportunity to set up some housekeeping. For example, you can use this event to change the record source to match whatever record source is selected in a form. Let’s say that you changed the record source in the form from the 2001 year records to the 2000 year records. Obviously, you would want the record source in the report to match your form. You could create another report, but as long as the table or query structures match, that’s not necessary.

You can click the Properties button while in Design mode of a report. After the report’s properties are open, you can access this event. You also can access ...