Close Event [Access 2003 VBA Language Reference]

The Close event occurs when a form or report is closed and removed from the screen.

Private Sub object_Close()

Object   The name of a Form or Report.

Remarks

To run a macro or event procedure when this event occurs, set the OnClose property to the name of the macro or to [Event Procedure].

The Close event occurs after the Unload event, which is triggered after the form is closed but before it is removed from the screen.

When you close a form, the following events occur in this order:

Unload → Deactivate → Close

When the Close event occurs, you can open another window or request the user's name to make a log entry indicating who used the form or report.

The Unload event can be canceled, but the Close event can't.

Applies to | Form Object | Report Object