Display error on nodata in subreport.

J

Joel

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

Thanks
 
S

Sharkbyte

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
 
J

Joel

Thanks for the idea Shark,
after about a 1/2 hour I finaly got it to work the way I needed.
 
Top