After Logon display User information

[scopes456]

I have a logon screen where user select there name and login. ( data is feed from Employee table). From the logon screen to the main screen i use Set Temp Var which takes the EmployeeID of the person logon and display it on the main form.Is there any way i can have that main form pull addition data for that user (name,job tittle etc).


Example John EmployeeID is 1, so after he logs in on the main for in EmployeeID it display 1 (using Set temp var), i have other text box where i would like it to display his name and other information which is store in Employee table.

Thank you

 

[pbaldy]

Since you want multiple values I'd use a recordset with the EmployeeID as a criteria. You could also use a DLookup() for each value if you're more comfortable with that.

 

[scopes456]

phaldy thank you, was able to use DLookup()

 

[pbaldy]

Happy to help!