How do I Assign a Numeric Value to Combo Box Selections that are a Text DataType??

[LearningOnTheFly]

Hello everyone!

Help! I have created combo boxes in several tables in which I need to assign a numerical value to each option chosen so I can calculate a numerical “score” based upon what each user has selected.
For example:
Not Applicable = 0
Introduced = 1
Emphasized = 2
And so on and so forth…
How do I do this?
Any help is greatly needed and appreciated!<o>
</o>
(I am using MS Access 2007)

 

[revver]

I do not want to seem picky but combo boxes relate to forms (or reports) and not to tables. Therefore they do not have a DataType. If they are bound to a field in a table/query then the field has the DataType. This makes it difficult to understand your question. Also, I am uncertain whether you have the same issue several times or whether the combos are combined to give a single score.

However, I'll assume that you have a combined Score field in your table and several combos on the form. You can set each combo to select a value in the usual way, either from a lookup table or a list specified in the RowSource. Then in the form's BeforeUpdate event you can calculate the score and assign it to a hidden textbox bound to the Score field.

I must say though that I haven't used 2007 much at all so if I have assumed wrongly please clarify.