ACC: BeforeUpdate and AfterUpdate Field Properties Not Working
ID: Q100134
|
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.
The macro or function attached to the BeforeUpdate or AfterUpdate
property of a bound control does not run when expected.
CAUSE
The BeforeUpdate and AfterUpdate events of a bound control will not be
triggered if the bound control was modified by a macro or by code.
RESOLUTION
You can work around this behavior by causing the macro or code that
modifies the bound control to manually trigger the event pointed to by the
BeforeUpdate or AfterUpdate property of the bound control.
STATUS
This behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb (or NWIND.MDB in Microsoft Access
2.0 or earlier).
- Create the following macro called TestCityForNull:
Macro Name Condition Action
----------------------------------------
TestCityForNull IsNull([City]) MsgBox
... CancelEvent
TestCityForNull Actions
-------------------------------------
MsgBox:
Message: City Is A Required Field!
- Create the following macro called SetCityToNull:
Macro Name Action
--------------------
SetCityToNull OpenForm
SetValue
SetCityToNull Actions
---------------------
OpenForm Action:
FormName: Customers
View: Form
SetValue Action:
Item:[Forms]![Customers]![City]
Expression: Null
- Open the Customers form in Design view and select the TestCityForNull
macro in the City control's BeforeUpdate property.
- Run the SetCityToNull macro. Note that it successfully blanks out the
City field (you can press ESC twice to get it back). If the control's
BeforeUpdate event had been triggered, the TestCityForNull macro would
not have allowed the field to be blank.
- Try to blank out the City field manually. The TestCityForNull macro will
be triggered, displaying the following message:
City Is A Required Field!
- Do not save changes when you close the Customers form.
REFERENCES
For more information about the order of event properties, search for
"Event procedures," and then "order of events" using the Microsoft Access
97 Help Index.
Additional query words:
before after update ui
Keywords : kbusage FmsEvnt
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbprb