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

  • Thread starter Thread starter Jeffrey K. Ries
  • Start date Start date
J

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
 
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
Click to expand...
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
Click to expand...
module "fOSUserName" provides the
 
Thank you, that did it.

Jeffrey K. Ries


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


Chris


module "fOSUserName" that I got
module "fOSUserName" provides the
Click to expand...
 
Back
Top