Additem to ComboBox using the Column Property

's Computer Specifications

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

's Computer Specifications

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

vqthomf wrote:
> 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

's Computer Specifications

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

"JW" wrote:

> ComboBox1.AddItem .Fields(0).Value
> ComboBox1.List(ComboBox1.ListCount - 1, 1) = .Fields(1).Value
>
> vqthomf wrote:
> > 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
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
AddItem to Worksheet ComboBox	Paul D Byrne	Microsoft Excel Programming	2	25th Jul 2008 04:28 AM
combobox column property or dlookup	=?Utf-8?B?Y3J0b3BoZXI=?=	Microsoft Access Forms	2	14th Mar 2007 02:08 AM
combobox additem action	=?Utf-8?B?SmFjaw==?=	Microsoft Access VBA Modules	3	9th Apr 2005 10:51 PM
combobox additem	masterphilch	Microsoft Excel Programming	2	25th Oct 2004 11:04 PM
Multiple Column ComboBox using Additem	Jimmi	Microsoft Excel Programming	2	24th Sep 2003 02:40 AM