Displaying multiple columns in combo box

[Max]

Hello all,

I have a combo box on my form. Source data for the combo
box is a select query that provides six columns of
essential information. When selecting a value form the
combo box user can see all six values in the drop down
list.

However, is there a way to have all six (or at least
three) values displayed when selection is made and control
has no focus any longer?

Please advise on possible solutions. Thank you.

 

[Chris]

There isn't any good way without a work around. It only
shows the first column.

You could hide the PK, Concatenate the next 3 columns:

Select ID, FirstName & " " & LastName & "-" & Office,
FirstName, LastName, OFfice From Table.

Otherwise, you have to mess with hidden controls. You
could just use 3 unbound text boxes, and set the data to
=Forms!FormName!ControlName!Column(2), etc.


Chris