How would I ensure that page headers don't appear unless there are records in the detail section, i.e. page 2 has headers with no data.

Also, I have a subreport. If it's recordsource returns no records the sub-report is invisible. How would I

a) make it visible.

b) Manipulate a label.caption on the main report to say there's no records.

Thatnks in advance.