Audit trail for unbound Access 2000 form

[COBRA via AccessMonster.com]

Hello,
I need some help in creating an audit trail for an ACCESS 2000 UNBOUND form
saving the 'OLD VALUE','NEW VALUE';TIME OF CHANGE';'USER'.
Thanks

 

[Allen Browne]

Access does not provide an audit trail, so you must program them yourselves.

For a bound form, you can use the events of the form.

For an unbound form, you must use the events of the control to store the
original value (since there is no OldValue available), for each control,
presumably in whatever code you use to load the record into the form, and
then compare the values before you write the changes to the table, and then
write the audit log based on the differences after your save succeeds.