No, that's not the intended results.
The code does delete from the temp table, but not from the actual log. Have
you get this distinction correct?
Until you get it debugged, comment out the error handers, by adding a single
quote to the 2nd line in each function, i.e.:
'On Error Goto...
You will then see any error, and can fix the problems. Once it is working
correctly, remove the quote mark again.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Bradley Burton" <br***********@comcast.net> wrote in message
news:Oc********************@comcast.com...
I've successfully set up Allen Brown's code for audit logging
(http://allenbrowne.com/ajbAudit.txt), but I think there is something
wrong. It creates only one log of what the user did. The next time the
user edit's or updates the form it will overwrite the previous log record
in the table in the table. So basically my aud table shows only the most
recent record of what the user did. Is it supposed to be like this? I
was hoping I could make it save the log records in my aud table so I could
have a record for each time a user made a change instead of having it
replace the previous log. Any help would be appreciated.
Thanks,
Brad