Printing a sub form report from the main form

[goldxr]

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_Cli ck()
On Error GoTo Err_cmdPrintMin _Click

DimstDocName As String

stDocName = "rptMIN"
DoCmd.OpenRepor t stDocName, acNormal

Exit_cmdPrintMi n_Click:
Exit Sub

Err_cmdPrintMin _Click:
MsgBox Err.Description
Resume Exit_cmdPrintMi n_Click

End Sub
[code]

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

Cheers