Can information from 2 columns show in one combo box?
 

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

Can information from 2 columns show in one combo box?
 

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)

"Cheryl" wrote in message
...
Is there a way to populate a combo box with 2 columns.. like description
and
part number..? from a table??

Can information from 2 columns show in one combo box?
 

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

"Bob Phillips" wrote in message
...
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)

"Cheryl" wrote in message
...
Is there a way to populate a combo box with 2 columns.. like description
and
part number..? from a table??