Who is logged in?

  • Thread starter Thread starter Timothy Millar
  • Start date Start date
T

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.
 
Set the control source of a text box on your form to
=DLookup("EmployName","tblEMPLOYEE","EmployLogIn = '" & Me.[LAN ID] & "'")
 
Back
Top