I am stuck with a bit of code that i have used to create an Audit log of users changes on a form.
At the moment the code uses the "currentuser ()" to tell me who has made these changes. ( see below )
'Set date and current user if form has been updated.
MyForm!Updates = MyForm!Updates & Chr(13) & Chr(10) & _
"Changes made on " & Now & " by " & CurrentUser() & ";"
I am currently using a security login form that opens when first entering the database. The user must enter their username and password. It is this Username that i would like the audit trail to pick up and not the Currentuser().
Is there a way to do this?? Im not very clever at this code bit.!
Thanks for the help.
At the moment the code uses the "currentuser ()" to tell me who has made these changes. ( see below )
'Set date and current user if form has been updated.
MyForm!Updates = MyForm!Updates & Chr(13) & Chr(10) & _
"Changes made on " & Now & " by " & CurrentUser() & ";"
I am currently using a security login form that opens when first entering the database. The user must enter their username and password. It is this Username that i would like the audit trail to pick up and not the Currentuser().
Is there a way to do this?? Im not very clever at this code bit.!
Thanks for the help.
