Fill Combobox through code

[D.W. Schingenga]

I managed to fill a combobox through code:

cbo.AddItem rs.Fieds("field")

Problem I have now is that I need to have 4 columns, the code above will only give requested field. If I use & sign it will add the fiels, however in the same column.

How can assign fields to a specific column?

Thanks,

Dirk

 

[ColinEssex]

I've not done it but is it

cbo.AddItem.Column(0) =  rs.Fieds("field")

Column(0) being the first one, then (1), (2) etc etc

I may be totally wrong though

Col