Combo box with 2 columns

[awelch]

Is there a way to load a combo box from a SQL db with 2 columns of information? I have a select statement that is pulling these fields from the db: YardID and Yard, but I am unsure on how to get both fields into the combo box in column format.

Any help would be greatly appreciated.

Andrea

 

[RonVaught]

Visual Basic's combo boxes do not have support for multiple columns. You could add both fields to a combo box but they will both have to be in a single column.

 

[RayGibbins]

Use the ItemData Property to hold the YardID


Loop through the Objects

Combo1.AddItem Object.Yard
Combo1.ItemData(Combo1.NewIndex) = Object.YardID

Private Sub Combo1_OnClick()

Msgbox Combo1.ItemData(Combo1.ListIndex)

End Sub