Assigning value to dropdown list in a combo box & getting value for calculations.

[siapliw]

Hi,
I am a newbie to Access.
I want to create a drop down list called pH, BP, etc.
The pH list contains math expressions as text e.g. >=7.7, 7.6-7.69, 7.5-7.59 and so on. User selects one value from this drop down combo in the form.


Each label has a value. e.g. >=7.7 has 5, 7.6-7.69 has 4, 7.5-7.59 has 3, etc. The value from the user selected label, will be used to make calculations and get the final score.
How to go about this? Please help.

[RuralGuy]

Create a Table with these two fields with the actual value as the first field and make it an integer field. The second field will be a Text field. Set the RowSource of your ComboBox to this table and hide the 1st field (ColumnWidth = 0") Your bound column will be 1.

[siapliw]

Thanks very much, RuralGuy. It's perfect.

[RuralGuy]

Glad we could help.