So here is my problem...I have two forms; frmUserLogIn and frmUserInterface
What I want to happen is when the user selects their name from the log in screen and hits "enter" I want the User interface to come up with their name at the top of the form. So far I have only been able to get the ID number associated with the user to come up. How do I change the control so that the name appears and not a number?
The Log In form uses a cbo for them to select their name from. I am using WHERE ((([tbluDivision POC].PointOfContact)=[Forms]![frmUserLogIn]![User Name cbo]));
The area on the tbluDivision POC is where the actual name is listed and not the ID number.
I have also tried to use WHERE (((tbluShop.PointOfContactID)=[Forms]![frmUserLogIn]![User Name cbo]));
But it has the same results regardless.
Any help would be great, and Have a Nice Weekend!!!!!