Checking for field update

[John]

Hi

is it possible to check if certain fields have been changed, just before the
record is saved?

Thanks

Regards

 

[Guest]

John,

Although there is not a specific property for an individual field to tell
you that the field has changed, you can use the "Tag" property of any field
to set a value that will indicate that the field has been changed.

Just use the On Change event of the field and use code to set a value in the
Tag property of that field, like:

me.tag = "Changed"

Then just before before the record is saved, just check the value of the Tag
property of each field you need to check.

 

[Van T. Dinh]

In the Form_BeforeUpdate Event, you can check the (bound) Control.Value
against the same Control.OldValue to see if the value of the binding Field
has been changed or not.