Can information from 2 columns show in one combo box?

C

Cheryl

Is there a way to populate a combo box with 2 columns.. like description and
part number..? from a table??
 
B

Bob Phillips

Cheryl,

set the columncount property to the number of columns and just link to the
table.

You can get the data like

With Me.ComboBox1
MsgBox .List(.ListIndex, 0)
MsgBox .List(.ListIndex, 1)
End With


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
C

Cheryl

Thank you .. I will give that a try...

Bob Phillips said:
Cheryl,

set the columncount property to the number of columns and just link to the
table.

You can get the data like

With Me.ComboBox1
MsgBox .List(.ListIndex, 0)
MsgBox .List(.ListIndex, 1)
End With


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top