Hi,
Has anyone come across a print report macro that updates any changes you make on a main form?
The issue I have is I have a pivot chart called [frmMIN_PivotChart]
It is a sub form in the main form [frmMain]
I have a cammand button that prints the report [rptMIN]
However when you make changes to [frmMIN_PivotChart] on [frmMain] and hit the command button it does not print the changes.
I made the initial macro to code below, can I do it in a macro or can I alter the code below?
-
Private Sub cmdPrintMin_Click()
-
On Error GoTo Err_cmdPrintMin_Click
-
-
Dim stDocName 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
-
The reason your changes don't print, you have to be able to make the changes on the pivot table that is in the report. the one on the form is a separate piviot table. If you're wanting to make changes to the piviot table in the Access Report, you'll need to make the changes in code, then after that is completed and rendered, then you can print it out.
If you need a more detailed answer, I would have to have you post the report and the table schema and queries and forms that you have and how you have it setup.
Hope that helps,
Joe P.