Changed fields/values on a form

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
 
Back
Top