ACC2000: In a Report, Close Event Occurs Before Deactivate Event

• Microsoft Access 2000

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

The sequence of the Deactivate and Close events for a Microsoft Access form are the reverse of the Close and Deactivate events in a Microsoft Access report.

MORE INFORMATION

When you close a form, the following sequence of events occurs for the form:

Unload => Deactivate => Close

Close => Deactivate

Steps to See this Behavior in a Form

1. Open the sample database Northwind.mdb.



2. Open the Employees form in Design view.



3. Set the form's OnDeactivate property to the following event procedure:




Private Sub Form_Deactivate()
   MsgBox "Deactivate event"
End Sub 

4. Set the form's OnClose property to the following event procedure:




Private Sub Form_Close()
   MsgBox "Close event"
End Sub 

5. Save and close the form.



6. Open the Employee form in Form view.



7. Close the form.
   
   Note that the Deactivate message appears before the Close message.

Steps to See this Behavior in a Report

1. Open the sample database Northwind.mdb.



2. Open the Customer Labels report in Design View.



3. Set the report's OnDeactivate property to the following event procedure:




Private Sub Report_Deactivate()
   MsgBox "Deactivate event"
End Sub 

4. Set the report's OnClose property to the following event procedure:




Private Sub Report_Close()
   MsgBox "Close event"
End Sub 

5. Save and close the report.



6. Open the Customer Labels report in Print Preview view.



7. Close the report.
   
   Note that the Close message appears before the Deactivate message.

REFERENCES

For more information about the order of events, click Microsoft Access Help on the Help menu, type find out when events occur in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: inf

Keywords : kbdta FmsEvnt RptEvent
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbinfo