AutoFill User Info

[andy-29]

I would like to autofill a field in a form based on the user's login name. Have access pull the username from the logged on user.

[alansidman]

Look at this thread using the Environ(Username)

http://www.access-programmers.co.uk/...d.php?t=221559

[andy-29]

I'm getting #Name? on the field??

[alansidman]

Where are you putting the function. It is a vba function. Did you create the GetWinUser function? Share what you did, so that we don't have to guess. The more information the better.

Alan

[andy-29]

Ok, got it to work with a code provided by Dev Ashish.
Link: http://access.mvps.org/access/api/api0008.htm

Thanks!