Surpress subreport and report fields

[kronar]

How would I surpress a subform and some report labels if there are no records in a subquerry? And what module would I insert the code??

 

[dhookom]

Could you be more descriptive? If you have a subreport that returns no "child" records then the subreport will not display.

Anytime you want to modify objects in a report, you would generally add code to the On Format event of the section of the report containing the objects.

Duane
Hook'D on Access
MS Access MVP

 

[kronar]

Since Column headings did not show up in the subreport, I placed them in the report. If no children the subreport does not show, but I need to hide the column headings in the report.

 

[dhookom]

Put the column headings back in the subreport. Don't use the Page Header section of the subreport. Use the report header or a group header section.

Duane
Hook'D on Access
MS Access MVP