ACC: BeforeUpdate and AfterUpdate Field Properties Not Working (100134)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q100134
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
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.
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.
Modification Type: | Major | Last Reviewed: | 5/6/2003 |
---|
Keywords: | kbprb kbusage KB100134 |
---|
|