Assigning a value to combo box choices?

[Hopeloma]

Hi everyone, I am new here. I have to use Access to input data for my internship. It is not an IT internship, so knowing how to use Access wasn't a requirement. I do know some coding but I'm pretty rusty.

My question is I am using a combo box for a couple columns. The first one consists of " ";"None - 0";"Low - 1";"Moderate - 2";"High - 3";"Extreme - 4" and the second one is " ";"None - 0";"Low - 1 (0-20%)";2;"High - 3 (40-60%)";"Very High - 4 (60-80%)";"Extreme - 5 (80-100%)". I want to be able to multiply the numbers in these together to create a new column of the product. However, as you know this calculated field doesn't work if you have anything other than a number in the drop down choice. I want to have the words such as none, low, moderate, etc. in there as well though. Is there a way to assign just a number to each choice so that when you choose the option you can see the entire string (ex. "Low - 1") but then on the back end it multiplies the number I assign to it (ex. 1) to get a final product?

I hope this makes sense. Thank you very much in advance for your help!

-H.W.

[aytee111]

Are all of these three values in one combobox? Or are they separated into two? Can the calculated value be placed in a separate textbox and calculated depending on the values entered in the combobox(es)?

Please explain exactly what you are trying to accomplish with these values, with examples.

[ssanfu]

Pretty vague.

The first one consists of <snip>

The first one what?? I'm going to guess you are talking about the combo boxes.

<snip> and the second one is " ";"None - 0";"Low - 1 (0-20%)";2;"High - 3 (40-60%)";"Very High - 4 (60-80%)";"Extreme - 5 (80-100%)". I want to be able to multiply the numbers in these together to create a new column of the product.<snip>

My Crystal Ball is in for repairs, I loaned out my Tarot cards and I can't find my I-Ching sticks. So I'm going to use WAGs. (not very scientific)



Both of the combo boxes have a Row Type property of "Value List".

Combo1 Row Source property will be
0 ; "";0 ; "None - 0";1;"Low - 1";2;"Moderate - 2";3;"High - 3";4;"Extreme - 4"

The Bound Column = 1
Limit To List = Yes
Column Count = 2
Column Widths = 0


Combo2 Row Source property will be:
0;"";0;"None - 0";1;"Low - 1 (1-20%)";2;"Moderate - 2 (21-30%)";3;"High - 3 (41-60%)";4;"Very High - 4 (61-80%)";5;"Extreme - 5 (81-100%)"
(I added the RED option......)

The Bound Column = 1
Limit To List = Yes
Column Count = 2
Column Widths = 0



In a text box on the form, the Control source would be

=[Combo1]*[Combo2]