Who is logged in?


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.
 
Ad

Advertisements

R

RonaldoOneNil

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top