By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Printing a sub form report from the main form

P: 3
Hi I'm pretty new to access and have very little VBA experience, so I apolgise if its a stupid question but I can't seem to figure this one out.

I have constructed a main form with different pivot tables and pivot charts which are inserted as sub forms.

I made a report for each pivot chart form for printing purposes and inserted a command button on the main form to print the report.

I found out however that when I use the drop down filter categories on the pivot chart in the main form this is not done in the report that prints.

Here is the code for the print button;

[code]
Private Sub cmdPrintMin_Click()
On Error GoTo Err_cmdPrintMin_Click

DimstDocName As String

stDocName = "rptMIN"
DoCmd.OpenReport stDocName, acNormal

Exit_cmdPrintMin_Click:
Exit Sub

Err_cmdPrintMin_Click:
MsgBox Err.Description
Resume Exit_cmdPrintMin_Click

End Sub
[code]

If someone could give me a few pointers that would be great

Cheers
Mar 10 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.