Selecting A Value From An Unbound Combo Box In Access 2000

Selecting a value from an unbound combo box in Access 2000

Hi,

I am attempting to default a combo box to a value I have passed in. I have already populated the combo box dynamically by setting the column numbers and widths and specifying the row source as Value List, supplying the row source string.

Since I am working with classes and collections, I wish to avoid data binding as I would prefer that the classes handle everything, which they can do.

Now my problem is that I cannot find how to select the correct value on the dropdown after populating it with all the values. When I try a line like:

cboAppType.Column(0) = lngValue (where lngvalue corresponds with a value in the list)

it returns the error "object required". It won't recognise the column at all, even though it sees and displays the rows and columns.

I am beginning to tear my hair out as I have been struggling against Access all the way to try and implement unbound combo boxes and listboxes and having overcome everything else, I'm stuck just here.

Any help very much appreciated - thank you