Autofill Text Box with name based on Network User ID

[sandiclaus]

Hi,
I am desperate for help! I am developing a time-tracking database with a time-entry form which will be used by each person in our dept.
I have a query that uses a function and identifies the network user ID of the person logged on and their name. I would like the employee name to autofill when the time entry form is opened. How can I do this??
Here is the SQL for my GetUser query:
SELECT Employees.UserID, Employees.[Employee Name]
FROM Employees
WHERE (((Employees.UserID)=NTDomainUserName()));

Sandi

 

[DJN]

In the On Open event procedure of the form, add me.TextBoxName=NTDomainUsername()

David

 

[sandiclaus]

Thanks David- that worked and did autopopulate the network user ID.
Now how do I get it to actually fill in the Employee's name?
Sandi