Who is logged in?

[Timothy Millar]

I am looking to identify who is currently logged onto the LAN but instead of
returning their login ID I want to pull their name from a table. Here is
what I have;

tblEMPLOYEE
EmployID (Number)
EmployName (Text)
EmployLogIn (Text)

I have a form that when it opens it will pull the End-Users LAN ID but I
want it to go to the Employee Table and enter in the employee's name instead
of the LAN ID. Example: LAN ID = brownj. When is entered into the form is
"James Brown". Thank you.

 

[RonaldoOneNil]

Set the control source of a text box on your form to
=DLookup("EmployName","tblEMPLOYEE","EmployLogIn = '" & Me.[LAN ID] & "'")