How do you check check if current record has been edited?

[GreenFella]

Is there any way using VBA to check to see if the data on the current record of a form has been edited?

I want to be able to invoke an edit checking routine for a current record only if it is a newly added record, or if any of the data on the record has been added.

Otherwise, I want to skip the edit checking routine.

Does anyone have any suggestions?

TIA
GreenFella

 

[jitter]

If you are using bound data on a form them you can look into the 'dirty' property.