Adding more than 1 expression in control source

[Probie]

Hi, how do you add more than 1 expression in the control source



I currently have =IIf([a]="x" And [b]="y","z","")

I want to have the same thing but change x, y & z

Thanks

[pbaldy]

You can't, but you can have a more complicated expression. I saw your other thread, so rather than us try to hit a moving target, why don't you post your actual problem? Posting pieces of it may seem logical to you, but in reality the answer will often change with the question.

[Probie]

You can't, but you can have a more complicated expression. I saw your other thread, so rather than us try to hit a moving target, why don't you post your actual problem? Posting pieces of it may seem logical to you, but in reality the answer will often change with the question.

Thanks, I thought I would try try & figure it out first before asking but at times it looks confusing.


What I wantb to do is make a Risk Management thing, a table with 3 Rows (Low/Medium/High) & Coloums Likely/moderate/Unlikely, I have set up these as values on a table as as you can see from the attachment when you choose something a corrosposinding note opens up, I want to put the risk number automatically into another box (See Risk Assessment Given Box), This will also go into a report.

I have done it for 1 setting eg: High & Likely but can not seem to do it for the others moderate/Medium etc....

Any advise would be greatful

I hope I have emplained it easier enough

[Probie]

After further searching & reading I figured out how to put more than 1 expression in I used the following:
=IIf([a]="b" And [c]="d","e",IIf([f]="g" And [h]="i","j",IIf(k]="l" And [m]="n","o")))

This seems to work