User ID

[Wet_Blanket]

Good Morning, and a Happy Festivus.

I have a form on Access 2003 that a user will use to input data into an account table. Because a number of users will be on this database, I have created user IDs (via Security Wizard) that they log in with.

I want to create a sort of audit trail, so that when they create a new account (using the form), their user id is stored in the table.

Any suggestions?

 

[TallMan]

You could do something like after they log in there is a text box hidden on the form that has their user ID. Once they enter the information into the table create it where the user id inserts into the table.

 

[Wet_Blanket]

I was thinking of doing that, but I don't know how to code the USER ID into VBA.

 

[boblarson]

I was thinking of doing that, but I don't know how to code the USER ID into VBA.

If you are using Microsoft Access Security, then you can get the currently logged in user by using:

CurrentUser()

For example:

Me.YourTextBoxNameHere = CurrentUser()

will return the current user name to a text box on the form.

 

[Wet_Blanket]

worked great. thanks.