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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

comboboxes, extracting specific item 7
Linking Combo Box Values to Access Table 2
combo box 2
How to populate Combo Box ?? 3
Cascading Combo Box & Content Filtering 1
Use VLOOKUP to populate text box on form 8
Reference Combo Box to Column of Data 1
Having trouble with combo boxes. 11

Back
Top