Getting Current User ID

[TheDan]

I'm creating a database for a college assignment, and for this database, I need to record the current user ID when a record is created/updated. But I dont know the function (like, Now() returns the current date/time) that gives me the user ID. The help files are awful and I cant find the function I need =(

 

[Smart]

Currentuser will return the user id (if no user logins are used it defaults to admin).
If you have created user logins and passwords (secured database) currentuser will return the username of the person logged in

 

[KeithG]

If you want the User ID of the person logged into windows you can use the Environ() function