Prev: Open form when database opens
Next: hidden form
From: Timothy Millar on 29 Apr 2010 10:16
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.
From: RonaldoOneNil on 29 Apr 2010 11:22
Set the control source of a text box on your form to
=DLookup("EmployName","tblEMPLOYEE","EmployLogIn = '" & Me.[LAN ID] & "'")

"Timothy Millar" wrote:

> 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.
 | 
Pages: 1
Prev: Open form when database opens
Next: hidden form