Saving a record to a different table on 'BeforeUpdate'

[Guest]

For audit purposes, I need to be able to save a record to a different table
before Access 2003 writes any changes to the original table.

 

[Allen Browne]

You can use Form_BeforeUpdate to read the OldValue of each field, and
execute an Append query statement to add another record to another table.
But you don't know if the write will succeed or not, so the audit log could
contain invalid records (writes that failed.)

If you want to audit the deletion of records as well, things get more
involved, as a user can select multiple records at once.

For details on how to use the form events, see:
Audit Trail - Log changes at the record level
at:
http://allenbrowne.com/AppAudit.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...