User Id

[akshal]

i plan to use the Group security feature for my DB.... using the user ID and password... i also want to make use of the user ID in the autopopulating of some of the field in my forms.... if for an instance the person logged in is akshal... then the a particular field named "filled in by" is to be autopopulated by the user ID (i.e. akshal)

 

[namliam]

Environ("Username") will retrieve it for you in A2k or above....

 

[ghudson]

If you are using Access security with a custom workgroup then the CurrentUser() function will return the ID that the user logged in with. Admin is the default ID since all db's are actually secured.