Changed fields/values on a form

[John]

Hi

Is it possible to get a list of fields a user has changed on a form before
the form is saved, for history purposes? If I can also get the new values
for these fields then that would be even better.

Thanks

Regards

 

[Douglas J. Steele]

Assuming it's a bound form, each of the controls has an OldValue property
that you can compare to the current value of the control. Therefore, in the
form's BeforeUpdate event, you could loop through all of the controls on the
form, and check if their values changed.

You might also take a look at what Allen Browne has at
http://www.allenbrowne.com/AppAudit.html