By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,436 Members | 2,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,436 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;

Private Sub cmdPrintMin_Click()
On Error GoTo Err_cmdPrintMin_Click

DimstDocName As String

stDocName = "rptMIN"
DoCmd.OpenReport stDocName, acNormal

Exit Sub

MsgBox Err.Description
Resume Exit_cmdPrintMin_Click

End Sub

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

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.