Populate textbox from a matrix (1 Viewer)

[Carl_R]

It's been a while - good to be back!

I have a Priority matrix (see attachment)

To calculate the Priority, one would select the Urgency and then the Impact. Example: a Medium Impact Sev2 would have a Priority of 2.

What I have are 3 bound text boxes - one called Urgency, one called Impact and one called Priority that I would like to autopopulates based on input in the first two text boxes.

So, if Urgency = 1 and Impact = 1 Then Priority = 1
If Urgency =1 and Impact = 2 Then Priority = 2
And so on...

I have been thinking about using 'Case' but wondering if anyone had a better idea.
Thanks in advance

 

[WayneRyan]

Carl,

Using a table is easiest.

tblPriority
===========

Urgency  Impact   Priority
=======  ======   ========
   1        1         1
   1        2         2
   1        3         3
   2        1         2
   2        2         2
   2        3         3
   3        1         3
   3        1         3
   3        2         3

Me.Priority = DLookUp("[Priority]", "tblPriority", "[Urgency] = " & Me.Urgency & " And [Impact] = " & Me.Impact)

Wayne

 

[pbaldy]

My first thought is a table with fields for Urgency, Impact, and Priority. Your matrix would be 9 records in that table. Then you can get the values from anywhere with a DLookup, recordset or even a join in a query.

 

[pbaldy]

Great minds think alike, but some type faster than others.

 

[Carl_R]

I knew it would be something really simple! Thanks a lot. You've saved me another sleepless night