Track Changes

[Nicole]

Hello:

I have a shared database running on a network drive. I
would like to track when record changes occur and who did
it.

Problem 1: I'm not able to tack changes, when they occur
in subforms. (I have a main form with 3 subforms)

Problem 2: for CurrentUser I'm currently getting "admin",
since I don't have any security levels set up, however
everybody in our system has to look on each machine here,
is it possible to read the general user NetID and put it
in my filed CurrentUser?

I would really appreciate any help.

Nicole

BeforeUpdate Event:
Me![Last Change] = CurrentUser() & " " & Now()

 

[Roger Carlson]

On my website (see sig below) are two small sample databases:
"AuditTrail.mdb" and "AuditTrail2.mdb" which illustrate how to do both of
these things.