display user logon name

[Lynn]

I would like the user logged into the data base to have his/her name appear
automatically in the name field of all edited records in a form

 

[Dorian]

I don't beleieve you can access the user's name unless you have the user
enter their name when they login or deduce their name from a table of login
id and name.

The login id (from Windows) is available by running:
Dim strUser as string
strUser = Environ("Username")

or you could use the function fosUserName (google it for details)

-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Douglas J. Steele]

I always cringe whenever I see someone suggest using the Environ function to
retrieve user information, given how easy it is to get around.

Far better is to use the GetUserName API call, as illustrated in
http://www.mvps.org/access/api/api0008.htm in "The Access Web"