Detecting changes on form

[John]

Hi

I have a form which has several sub forms. I need to check when anything on
a form is changed including on any of the sub forms. Would it be enough to
check the AfetrUpdate of the main form or do I need to check AfterUpdate of
each sub form too, or do something else?

Many Thanks

Regards

 

[Van T. Dinh]

Why would you use the AfterUpdate Event to detect change (in data)???

I think the more appropriate Event would be the Form_Dirty Event and you
need to use the Dirty Event of the main Form (for changes on the main Form)
and the Subform (for changes in the Subform).

 

[Anthos]

The problem with using the afterupdate procedure is that the update
has already occured,
By using the form.isdirty you get a bolean value as to whether any
changes have been made.

This is ideally the best way to check your code.
Also a better time to do this is on the BeforeUpdate procedure if you
wanted to put in any checking or the like.