I hope I explain this correctly.
I have a form (PCs) and a subForm (Notes).
I have a report (Prt21) with the subReport (Notes).
In the Form NOTES, I have a checkbox. Check to Suppress Printing that record.
In the NOTES Report subReport It prints a Note and the Entered Date.
In the controls for them I have:
=IIF([Flagger] is True, "REDACTED", [Notes] and =IIF([Flagger] is True, "", [EDATE])
When I run the report, if the Suppress Box is checked, it will not print the EDate or the corrospsonding Note.
If it's not checked, I get #Errors.
I'm including a PDF of a "report" for a dummy record.
Thanks
Vito
I have a form (PCs) and a subForm (Notes).
I have a report (Prt21) with the subReport (Notes).
In the Form NOTES, I have a checkbox. Check to Suppress Printing that record.
In the NOTES Report subReport It prints a Note and the Entered Date.
In the controls for them I have:
=IIF([Flagger] is True, "REDACTED", [Notes] and =IIF([Flagger] is True, "", [EDATE])
When I run the report, if the Suppress Box is checked, it will not print the EDate or the corrospsonding Note.
If it's not checked, I get #Errors.
I'm including a PDF of a "report" for a dummy record.
Thanks
Vito