Can't assign value to combo box

  • Thread starter Thread starter Mike Collard
  • Start date Start date
M

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
 
Have you tried putting the value desired in the default value of th
properties of that control.

Good Luc
 
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



------------------------------------------------
Click to expand...
 
What do you want "StrMyvalue" to be? The first record in the table or a
value form a query based on a condition?
 
Back
Top