Search results

Finally got it to work with the following: =DLookUp("OverallRisk","RiskLookup","Consequence= '" & [Cons_Level] & "' AND Likelihood= '" & [Like_Level] & "'") Thanks for your help Plog

Thanks Plog, I was playing about with Dlookup but how would I combine two fields into the Dlookup expression?

Hi all I have a form with two combo boxes that are used to populate Consequence and Likelihood within table RiskAssessment. I have added a calculated field to the same table called ConsLikeliCombo that combines Consequence and Likelihood. e.g. Consequence possible values in combo box: C1 C2 C3...