Can't assign value to combo box

[Mike Collard]

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

 

[Jim/Chris]

Have you tried putting the value desired in the default value of th
properties of that control.

Good Luc

 

[Mike Collard]

The combo has to be populated with the value held in a
table not a default value.

-----Original Message-----
Have you tried putting the value desired in the default value of the
properties of that control.

Good Luck



------------------------------------------------

 

[Jim/Chris]

What do you want "StrMyvalue" to be? The first record in the table or a
value form a query based on a condition?