Can information from 2 columns show in one combo box?

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

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)
 
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...
 
Back
Top