Default User Name

[billy]

How can I set the default value of a field to the login
user in Data Access Page?

Thanks.,

 

[Newbie]

Will the following work for you

Function fOSUserName() As String
fOSUserName = Environ("USERNAME")
End Function

frm.txtUserName = fOSUserName

this sets the field txtUserName to the windows login (Win 2k)

HTH
Al

 

[Douglas J. Steele]

I would strongly recommend not relying on the Environment variable (since
Environment variables are so easy to reset), and to use the API call shown
in http://www.mvps.org/access/api/api0008.htm at "The Access Web.