Coercing Combo Box Value Based On Bound Column?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coerce Combo Box Based On Invidible Column 0? 2
problem with mulit-column value list combo box 2
Combo box trouble 1
Force the users to enter value in a Text box based on a Combo Box 1
combo box data type 1
Combo Box Criteria Question 1
Combo Box QUESTION 5
Combo box based on another combo box 1

Top