Access 2002 Programming by Example

Defining Events

If you have worked with Access forms or reports, you have activated events. Every time you open or close a form and report, you activate the On Open and On Close events. The On Activate event occurs when the form becomes the active window. In contrast with many other object properties, event properties are initially left blank with no default values. If you set the event property to a macro, the macro runs when the event occurs. Let’s say you have a button on a form labeled Print Record. If you click this button when the form is open (not in Design view), the On Click event activates and runs the macro or procedure attached to the event. This procedure prints the current record of your form. If you want to issue a list of Visual ...