Print this Sub-report not That One

G

Guest

My main report has a group footer that has to print a sub-report. The
sub-report can be 1 of 2 that are available.

rptJoint
rptJointNone

If there are no records to be printed in the "rptJoint", the "rptJointNone"
sub-report is to be printed
Else the "rptJoint" sub-report is to be printed.

Is this possible and how?

Thanks in advance!

Dwight
 
G

Guest

I figured it out.

If Me.rptJoint.Report.HasData Then
Me.rptJointNone.Report.Visible = False
Me.rptJoint.Report.Visible = True
Else
Me.rptJointNone.Report.Visible = True
Me.rptJoint.Report.Visible = False
End If

Thank you!

Dwight
 

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

page header on second page of invoice. 3
Force new page after a sub-report 1
Access prints the form from wich the report is launch intead of th 1
Print report and subreport(no data) without blank page 0
Printing of sub-report skips to second page. 3
Totals are doubled when report is a sub report 3
Report Data Not Printing 4
Determining control’s position on a report 2

Top