Display error on nodata in subreport.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way that I can display an error message if there is no data in a
subreport and cancel printing?

Thanks
 
You could try to build a hidden sub-form on the report data, and run an IF
statement to see if it returned Null. If so, trigger your error, if not then
continue with your report.

Good luck.

Sharkbyte
 
Thanks for the idea Shark,
after about a 1/2 hour I finaly got it to work the way I needed.
 
You must log in or register to reply here.

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

Cancel printing if NoData 2
Reports/SubReports 2
Reports and SubReports Spacing 6
Report asks for Parameter and Won't Display Subreport 7
Access How to prevent subReport from breaking across pages? 1
Error when printing report 4
Display "No details" if subreport has no records 1
I want subreports to display in even if they have no associated da 3

Back
Top