Subreport is empty...need to show "No Records Found"

[Kathy]

I have a report with a subreport. I understand that when there are no records
in the subreport then it will display empty. I read in another thread that
you can put a control behind the subreport that will be visible when the
subreport is empty. I am trying to do this with a control that ="No Records
Found", but the control still shows up when the subreport has data. I tried
the On Format suggestion, but did not work out. I am a novice, so it was
probably my mistake...any further help is much appreciated.

 

[Duane Hookom]

Set the control source to something like:

=IIf(sbrptctrlName.Report.HasData,Null, "NO DATA")

 

[Kathy]

Thank you for your reply. I am still having problems...sorry, I am probably
doing something "obvious", but just not to me. Anyway, this is what I am
entering in an unbound textbox on the main form (not subform):
=IIf(strStatus.Report.HasData, Null, "No Data")

strStatus is on the subForm. But I am getting "#Name?" as the response.
Again many thanks for your help.

 

[Kathy]

Oops, just dawned on me...as had it in the wrong section. It is now
working...many thanks!