This is what I did. Type an immediate IF() statement.
Code:
iif(Condition,"Text",False)
Then, where ever there is a FALSE, paste the IF() statement again, for a total of 8 times.
(this is 4 times)
Code:
iif(Condition,"Text",iif(Condition,"Text",iif(Condition,"Text",iif(Condition,"Text",False))))
Next, where ever there is the word "Condition", replace it with your test:
Code:
iif([Forms]![Checklist]![RSwNO] And [Forms]![Checklist]![RDrNO],"Text",iif(Condition,"Text",iif(Condition,"Text",iif(Condition,"Text",False))))
And replace "Text" with your text:
Code:
iif([Forms]![Checklist]![RSwNO] And [Forms]![Checklist]![RDrNO],"The rear window switches and door handles are non-operational",iif(Condition,"Text",iif(Condition,"Text",iif(Condition,"Text",False))))
Do this for each of the 8 nested IIF() statements.
--------------------------------------
This is my attempt:
Code:
x = IIf([Forms]![Checklist]![RSwNO] And [Forms]![Checklist]![RDrNO], "The rear window switches and door handles are non-operational", IIf([Forms]![Checklist]![RSwMiss] And [Forms]![Checklist]![RDrMiss], "The rear window switches and the door handles are missing.", IIf([Forms]![Checklist]![RDrNO] And [Forms]![Checklist]![RSwMiss], "The rear window switches are missing and the door handles are non-operational.", IIf([Forms]![Checklist]![RDrMiss] And [Forms]![Checklist]![RSwNO], "The rear window switches are non-operational and the door handles are missing. ", IIf([Forms]![Checklist]![RSwNO] <> 0, "The rear window switches are non-operational.", IIf([Forms]![Checklist]![RDrNO] <> 0, "The rear door handles are non-operational.", IIf([Forms]![Checklist]![RSwMiss] <> 0, "The rear window switches are missing.", IIf([Forms]![Checklist]![RDrMiss] <> 0, "The rear door handles are missing.", ""))))))))