sub reports

[Guest]

I have a subform that i want to print on a new page if it has data in it. but
if there is no data i dont want the sub form to print. the way i have it now
it prints a blank page. i used a page break to send the form to a new page.

 

[Guest]

one approach: put a button on your Form for "Print"

that triggers two separate print commands for the Main Form and the
sub-Form...but have the sub-Form first check for a valid value in one of the
fields that would be populated if there is data...if no data then no print....

macros or vb