I have a combo box populated by SQL SELECT that shows the last name and the first name in the drop-down box in two columns. However, whenever the user makes a choice and presses , only the last name shows in the combo box. Also, whenever the user incrementally types a last name, the first name does not show.

I have tried all sorts of combinations to make both names appear, without success. How can I make the combo box show both names?

TIA.

John