populate an empty field from the result of 2 other fields

[darkrenown]

Hi

I have created a form that analyses the comitment of managers of a project I am managing. I have created 2 buttons for each of the following categories: influence / comitment 1 button is low with a value of 1 and the other is high with a value of 2.

What I am trying to do is populate a field (matrix)with 1 of 4 descriptions that autopopulates according to the values of influence and comitment.

So if influence = low (2) and commitment = high (2)then matrix = Champion

I think I need a select case statement but am at a loss

I would appreciate the help

Thanks

 

[Zion7]

well, you almost had it, as you wrote it above;

If Me.influence = 1 And Me.commitment = 2 Then Me.matrix = "Champion"