How do I pull an equivalent from a table in a form?

[Jeffrey K. Ries]

I am working on a form where I am trying to automatically fill in the users
name and Employee ID at the top. I have a module "fOSUserName" that I got
from this group which provides the Windows Login Name. I also have a table
called 'Employees' which contains all the needed info about every employee
including EmployeeID and LoginID. If the module "fOSUserName" provides the
LoginID how do I pull the equivalent EmployeeID from the table in the
default property of a combo box?

Thanks,
Jeffrey K. Ries

 

[Chris]

DLookup("EmployeeID","Employees","LoginID='" & fOSName()
& "'")


Chris

-----Original Message-----
I am working on a form where I am trying to automatically fill in the users
name and Employee ID at the top. I have a

module "fOSUserName" that I got

from this group which provides the Windows Login Name. I also have a table
called 'Employees' which contains all the needed info about every employee
including EmployeeID and LoginID. If the

module "fOSUserName" provides the

 

[Jeffrey K. Ries]

Thank you, that did it.

Jeffrey K. Ries

DLookup("EmployeeID","Employees","LoginID='" & fOSName()
& "'")


Chris


module "fOSUserName" that I got
module "fOSUserName" provides the