Coercing Combo Box Value Based On Bound Column?

  • Thread starter Thread starter PeteCresswell
  • Start date Start date
P

PeteCresswell

For instance:

cboRatingType
.RowSource="0;[NA];1;Fixed;2;Floating"
.BoundColumn=0
.ColumnWidth=0;.25

Datawise,

RatingTypeID_NA = 0
RatingTypeID_Fixed = 1
RatingTypeID_Floating = 2

Me.cboRatingType.Value=2 causes the box to show "2".

But I want to force it to show "Floating" - but without having to
stuff the literal value "Floating".
i.e. I want to do it based on the ID value - for which I have a global
constant defined.
 
Back
Top