Article ID: 109369
Article Last Modified on 5/6/2003
APPLIES TO
- 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