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

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??

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??