>>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

Carlos:
I have a rather complicated WHERE clause that makes SQL the best RowSourceType. Thanks for the suggestion, however: I will try doing that in the SQL statement.

John