Calculating values based on Combobox value

[BrianFawcett]

I am trying to write code that will calculate the value of a field in a report based on the value the user chooses in a comboBox (the values are 1-5). I know there are more efficient ways to do this than a large nested IF statement. Can some one help me out.

[maximus]

Select case may be some thing that you might be looking for.

Example:

Select Case Me.ComboBox1

Case is = 1
Me.Text1=Me.Text2*1
Case is =2
Me.Text1=Me.Text2*2
Case is =3
Me.Text1=Me.Text2*2
End Select

try this out let me know if you need any help. if This solves your problem mark the thread solved.