New records linked to whoever is logged in

[agrogers15]

I am creating a database where a user logs in, and I need any records they create to auto populate a field with their userid. Thank you in advance!

 

[Joe4]

You can do that, but only if you control all record input through forms (users should NEVER be referencing or entering data into the tables directly - they should only access/etner data through Forms).
See here for how to do what you want: Date stamp records and capture User name when data is added or changed - Microsoft: Access Other topics FAQ - Tek-Tips

 

[agrogers15]

Thanks Joe4! I think I'm getting closer to what I'm looking for. I want to use the CurrentUser() function but I'm not sure how to implement it. I've done some google searching but I only get very basic info. Could you write some sample code to put things into context?

Thanks!

 

[Joe4]

Both Environ("username") and CurrentUser() are built-in functionality.
Environ("username") uses the netowork ID and CurrentUser() uses the Access login, if you have set one up.

To see what each of them returns, just put a button on a Form, and place this VBA code on the ******* event of that button:

Private Sub Command24_Click()
    MsgBox "Network ID: " & Environ("username")
    MsgBox "Access ID: " & CurrentUser()
End Sub

The instructions in the link give you step-by-step instructions on how to get it to work. Just pick which the appropriate ID value you want to return, from those two options.
If you run into trouble, let us know which of the steps in the link is causing you issues.