I am getting the #ERROR on (New) record line from the following IIF statement. This is in the Control Source of a txtbox. What you see below does give me the proper Y or N when needed but the #ERROR does not look good. When I add NZ I get wrong number of arguments. I know I am missing something but I really do not see it. I am hoping a fresh set of eyes can see the fix.
=IIf(DCount("PropertyInspectionFollowupID","tblPropertyInspectionFollowupAttachment","PropertyInspectionFollowupID=" & [PropertyInspectionFollowupID])>0,"Y","N")