Set combo box selection in code

  • Thread starter Thread starter mscertified
  • Start date Start date
M

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.
 
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.
 
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.
 
Back
Top