PRB: OnExit Macro Runs with AfterUpdate Macro in Option Group

Article ID: Q109317
Creation Date: 02-JAN-1994
Revision Date: 01-DEC-1996

The information in this article applies to:

Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

Both the macro in the AfterUpdate property and the macro in the OnExit property of an option group will run when you update the option group, if the macro action in the AfterUpdate property is an ApplyFilter action.

RESOLUTION

Do not use a macro in the OnExit property of an option group if the option group's AfterUpdate property runs a macro that contains an ApplyFilter action.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0).

Create a new form based on the Employees table. Add the EmployeeID and LastName fields to the form.

NOTE: In versions 1.x and 2.0, there is a space in Employee ID and Last Name.

Create an option group on the form with two toggle buttons and set the following properties:

      Option Group: Test
         AfterUpdate: Macro1
         OnExit: Macro2
      Option Button: Button1
         Option Value: 1
      Option Button: Button2
         Option Value: 2

Save the form as Form1.

Create the following two new macros:

      Macro Name   Condition                Action
      -------------------------------------------------
      Macro1       Forms![form1]![test]=1   ApplyFilter
                   Forms![form1]![test]=2   ApplyFilter
      Macro2                                MsgBox

      Macro1 Actions
      ---------------------------------------------------------------------
      ApplyFilter
         Where: [EmployeeID]=5 (or [Employee ID]=5 in versions 1.x and 2.0)
      ApplyFilter
         Where: [EmployeeID]=7 (or [Employee ID]=7 in versions 1.x and 2.0)

      Macro2 Actions
      ----------------
      MsgBox
         Message: Test

Toggle between the two option buttons. Note that both the ApplyFilter and MsgBox actions are run.

REFERENCES

For more information about event properties, search the Help Index for "event procedures, event properties," or ask the Microsoft Access 97 Office Assistant.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.