Set combo box selection in code

[mscertified]

When you set a multi-column combo box value in code, is it sufficient just to
set the bound column or do I have to set all the columns? I only know the
bound column value and I'd prefer not to have to do a table lookup. Thanks.

 

[Klatuu]

The bound column is the only one that will respond to

Me.MyCombo = SomeValue

When that is set, the other column values will be the values for the
selection.

 

[Dale Fye]

The value in the bound column is also the value that will be stored in your
table if the combo box is bound to a field in the forms Record Source.