>I did try similar approach using query as rowsource and it worked but my client don't want to have extra step like SQL - statement.

PMFJI, but there is no way to display ALLTRIM( first_name ) + [ ] + last_name except by using a SQL statement unless the concatenated field is a part of the unserlying data source.

The combo box's DisplayValue always comes from the first column of its RowSOurce.