IIF Statement to alter field content

[matthewnsarah07]

I have currently got a frmTM which has three subforms that contain a series of check that a manager still needs to carry out. When all checks are completed obviously the subforms are blank.

I have also got three fields on the main form called [totalppe] [totalpwd] & [totalpb] - these show the result of a DCount and so if all checks are done they will all read zero

I now want to write an IIF statement to effect that if all these 3 fields are at zero than a fourth field [complete] displays "All Checks Completed"

How would phrase this statement and is there a quicker way of displaying something like this on an empty subform

Thanks for your help

 

[WayneRyan]

M&S,

Me.[FourthField] = IIf([totalppe] + [totalpwd] + [totalpb] = 0; "All Checks Completed", "Need more checks")

Wayne

 

[matthewnsarah07]

Thanks Wayne

You're solution worked straight off