Allen Browns audit log - doesn't save the log

[Bradley Burton]

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

[Allen Browne]

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