Autofill a field based on the selection of 2 other fields

[Archie1]

Hi -Is this possible please?
I have a form FrmRisklevel

It has fields Risk Probability and Risk Impact (both are from TblRisks and the fields are look ups from other tables) -
My next field is Risk Evaluation
My preference is Risk Evaluation will autopopulate based on the selection of the first 2 fields
Eg If "likely" is selected from Risk Probability and "Moderate" is selected from Risk Impact then it would autofil Risk evaluation with "Medium High"

 

[Ranman256]

you can use an update query that updates that field based on the 2 values picked.
put the form items in the query as criteria.

 

[Archie1]

I will have a go at that thank you

 

[Archie1]

Hi -Just to test this out I made a "test " table and "test"update query
The SQL is

UPDATE TEST SET TEST.RE = "low"
WHERE (((TEST.RP)="l") AND ((TEST.RI)="neg")) OR (((TEST.RP)="UL") AND ((TEST.RI)="MIN"));


This works for the above outcomes so can I now add to this for outcomes that would update field RE to "High" or would that have to be a separate update query?

Eg could I add an "and" or equivalent? Sorry -first time attempting this