Displaying multiple columns in combo box

  • Thread starter Thread starter Max
  • Start date Start date
M

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.
 
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
 
Back
Top