Hi all,

I've done a bit of searching but all the answers I am finding relate to a report, and not a sub report.

I've got a report set up which is working perfectly, it has several sub-reports running off their own queries and whatnot.

I've set the reports to can grow/shrink yes, which is great.

What I would like to be able to do, is if the sub reports have no data to return (for example if the record being queried has no entries in a particular table, which is quite likely) that rather than leave the heading and a blank section, it prints "No Records Found".

Is there any way to do this in VBA or some such? Note this is for a SUBREPORT linked via child/master on PatientID.