Jack said:
Can anyone please give me an example of when to use the
BeforeUpdate?
There are two different BeforeUpdate events. One is for
controls and is executed just before a new, user entered
value for the control is changed. This can be used to check
if the new value meets some requirements you want impose on
the value. This is not a fool proof point for validation of
a combinations of control values since some may not be set
at this point in time.
The other is the Form object's BeforeUpdate event. This one
occurs just before any changes to the current record are
commited to the underlying table. It can be used to verify
that the entire record meets you special validation
requirements, or to assign additional values such as a last
updated time stamp.
Maybe the above will give you enough background to make the
detailed explanations in Help more understandable.
