Can't assign value to combo box

I have a combo box whose RowSource is some SQL. When the form opens I want the combo box to display a value assigned by some code.

I have tried the following

me.Combo = strMyValue

AND

me.Combo.Column(0) = strMyValue

But the combo box displays -1 instead of the value I am trying to assign.

Any ideas?

Thanks

Mike Collard

Snowsride,

I found this in another forumn

Me.ListboxName.RowSourceType = "Value List" ' Type of source
Me.ListboxName.RowSource = strList ' Final string

For each record you add to strlist put a ; between them

strlist = strlist & ";" & Next value

S-