G
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.
before Access 2003 writes any changes to the original table.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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]...
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]...