listbox vs. combobox

[joeblow3]

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.

 

[Remou]

Comboboxes will only show one result. However, you can get round this by setting the row source to include two columns in one, for example:

RowSource: SELECT PersonID, Forename & " " & Surname FROM Persons

 

[TheAceMan1]

How are ya joeblow3 . . .

have a look at the [blue]Bound Column[/blue] property!

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[SeeThru]

And you can use the colum widths to hide colums you don't want - set them to 0

SeeThru
Synergy Connections Ltd - Telemarketing Services