Sub Report has no data

[drewduncan]

Anyone help??

Im opening a report which contains a sub report. The main (parent) report always has data but occasionally the sub (Child) report does not.

I would like the report not to open when the sub (child) report has no data in it.

I know there is the 'On No Data' Sub but not sure how to use it when the form with no data is a sub form.

Any help yet again greatly appreciated.

Cheers Drew.

 

[dhookom]

You can check the HasData property of the subreport from the main report using syntax like:
If Me.srptMySub.Report.HasData Then
'do something
End If
I'm not sure which event of the main report would be the best. You may need to experiment and then report back.

Duane
MS Access MVP