Good Afternoon,

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!!!!!
Thanks,
Kat

Hi Kat,

You can use the Column property of the combobox to refer to the column with the name in it.

Just my 2 cents...

It drives me crazy that these solutions are so simple, but I fight with it for hours to get it to work.

It works just like I wanted it too, and it only took seconds.

Thanks for the help!
Kat

Hi Kat,



Glad to hear you got it to work. It was the same for me too when I was first starting out.

Good luck with your project.