Auto fill text box based on login information from Environ("username")

[RoyLittle0]

Hi I have some forms which require the user to insert their name, when filling out data, is it possible to automatically insert their name based on the Environ("username") information I have a hidden text box on each form, that contain the Environ("username").

The user information is stored in "Employees" table under "UserName" and the full name is in a Query that looks up the FirstName and LastName from the Employees Table. Query is "Employees Extended" and the value is Employee Name.

the fields I want to auto fill are lookup fields from the "Employees Extended".
Any help would be appreciated.

[June7]

Yes, that is possible. Requires code. I use only VBA and don't know if macro can accomplish.

If the field you want to populate is included in the form's RecordSource, could be simply:
Me!fieldname = DLookup("LastName","Employees","UserName='" & Environ("USERNAME") & "'")

However, it is best to save employee ID instead of name.

The real trick is figuring out what event to put the code in.