Hiding specific detail controls when subreport has data

  • Thread starter Thread starter hornetsjaz
  • Start date Start date
H

hornetsjaz

Basically, I have a main report and two subreports. When the one
subreport has data I want to hide certain controls on the main reports
detail. Likewise with the other subreport.

Any suggestions?

Thanks
 
You can use code in the On Format event of the section of the main report
like:

Me.txtCertainControl.Visible = (Me.srptOne.Report.HasData = False)
 
Thanks a bunch! That worked

Duane said:
You can use code in the On Format event of the section of the main report
like:

Me.txtCertainControl.Visible = (Me.srptOne.Report.HasData = False)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SynNeed to account for null values in subreports 2
Hide one subreport if other has data 1
Using Subreports to create a Main Report 7
Main Report Header is on SubReport 4
Subreport page break in label controls or textbox controls 6
Hide Subreport on No Data 8
Hide Field on Subreport 4
Totalling SubReports - have tried and tried 7

Back
Top