list box versus combo box

[joeblow2]

Hi:
I have a listbox which has a Select statement( which returns two columns) as its Row Source.

Now, when I change the listbox to a combo box it works fine except that the dropdown choices show both the columns but when I select a choice, it only finally shows the first column.

The Combo box properties are all ok. It shows the same Row Source Type, Row Source, Column Count, Column Width, etc.

How can I please solve this.

Thanks in advance.

 

[pbaldy]

Define "solve this". A combo will only display one column when not dropped down. You can display the other column in a textbox:

=ComboName.Column(1)

 

[joeblow2]

Thanks Paul for your prompt reply.
Except I don't quite understand your response.
Where do I put the code:

=ComboName.Column(1)

Thanks

 

[John Big Booty]

Put it in the data source of your the text box you want to show the additional column/s (you will need a text box for each of the additional columns). Also remember that the columns in a Combobox are numbered from zero up.

 

[joeblow2]

Thanks a lot Paul and John! It works!