>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

John,
What about using allt(lastname) + ", " + allt(firstname) in rowsource and 6 in rowsourcetype?
Hope this helps