display muilti colums in combo box

S

stevo

Hi, I know I am missing something simple, but I still haven't found the
answer after searching through the help files and newsgroup.
I have a 3 column combo box that is a value list populated automatically
from a table. The fields I am using are ID, ciprefix, and cinumber. My column
width property is 0";.5";1". The drop-down list displays correctly, with a
list of all the columns I need, but after I select one of the rows from the
drop-down list, it only displays the value of the bound column (my bound
column property is 1) in the text portion of the combo box. What do I need to
do so that the entire row will be displayed in the textbox portion of the
combo box?
Thanks for your help!
 
O

Ofer

Create another text box next to the combo and in ControlSource property write :
=[ComboName].column(1)

To display the ciprefix field, if you want also the third field, you can write
=[ComboName].column(1) & " " & [ComboName].column(2)
 
G

George Nicholson

Add a 4th field to your recordsource:
[ID] & " " & [ciprefix] & " " & [cinumber] As Combined
and display that field in the combo. Combo's can only display one field in
their closed state.

HTH,
 
Top