Drop down shows both columns when selected

[chellebell1689]

Hello,
I've got a form with a drop down combo box with two columns. When you hit the down arrow it shows both columns, but when you click a choice, it only shows the data in the first column. How do I make it show both columns after it has been chosen?

Ex. First col is First Name, second col is Last Name. You click John | Smith and only John shows up. I want it to show John Smith

Thanks in advance.

 

[Galaxiom]

Create another column by concatenating the names in the RowSource query.

 

[CJ_London]

or have an unbound textbox control with a controlsource of =mycombo.column(1)

 

[chellebell1689]

Got it! Thanks!
(Sorry for the late reply, was sick yesterday)