Embedded pivot graph not updating within report

[mayhem11]

I have a report with an embedded pivot graph in the header. The report information is in the details with the labels in the header so all details are displayed correctly. My pivot graph does not update within the report. If I create a code that I will post below, both will update properly but only if they are separate entities.

Public Function GetPivot()
DoCmd.OpenForm "frmPivot", acFormPivotChart, , FilterFromList
End Function

Private Sub cmdReport_Click()
DoCmd.OpenReport "rptResults", acNormal, , FilterFromList
GetPivot
End Sub

I do not want separate results. I want the pivot graph to update the filterfromlist information just like the report updates properly.