Additem to ComboBox using the Column Property

G

Guest

Hi I have been trying to add to a combobox column using
ComboBox1.Column(0)=.Fields(0).value
ComboBox1.Column(1)=.Fields(1).value
but I keep geting an error can someone please point in the right direction.
TIA
Charles
 
J

JW

ComboBox1.AddItem .Fields(0).Value
ComboBox1.List(ComboBox1.ListCount - 1, 1) = .Fields(1).Value
 
G

Guest

Thanks I should of tried something like that because it's just like using the
listview
regards
Charles
 

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

list box remove item by combobox 4
Combobox - Problem on AddItem 11
excel sheet with control combobox 3
Populate combobox 6
Combobox selection to fill in textboxes 1
VB Combobox field problem in Excel 2000 3
Combobox display 1 value, access another 3
Add Item To ComboBox List 7

Top