display muilti colums in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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)
 
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,
 
Back
Top