Knowledge Base

ACC: Subform Control's Exit Event Not Activated (1.x/2.0)

Article ID: 109369

Article Last Modified on 5/6/2003

Microsoft Access 1.0 Standard Edition
Microsoft Access 1.1 Standard Edition
Microsoft Access 2.0 Standard Edition

This article was previously published under Q109369

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

SYMPTOMS

The macro specified for a subform control's OnExit property does not run if you exit the control by selecting a control on the main form with the mouse. The macro runs only if you select another subform control.

CAUSE

To activate the Exit event of a control on a subform, you must select another control on the subform.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database NWIND.MDB.
Create a new macro that uses the Msgbox action to display any text. Save the macro as Test.
Open the Categories Subform form in Design view.
Attach the Test macro to the Product Name control's OnExit property. Save and then close the form.
Open the Categories form in Form view. Select the Product Name field in the subform. Press ENTER and a message box with the text you entered in the macro in step 2 will appear.
Select the Product Name field again. Click anywhere in the main form. Note that the message box does not appear.

REFERENCES

For more information about the OnEnter and OnExit properties, search for "OnEnter" or "OnExit" using the Microsoft Access Help menu.

Keywords: kbprb kbusage KB109369