mischief911
Technical User
Hello
I am using MS Access 2003
I have used a Pivot Table 11.0 Active X object within eight subreports that are linked to a Main Report using the same Master/Child Link Field: SellerNumber
I am trying to find a way to use VBA to refresh several subreports within a Main report which each contain an Microsoft Office PivotTable 11.0 component. The Master and Child Link Fields for the Main Report are "SellerNumber".
I have written vba code in a module which will open a MS Access Report and iterate through a list of Account Reps generating one *.snp file containing all of the seller reports for a given account rep. This code generates the *.snp file without a hitch. However, none of the pivot tables contained withn the Main report's subreports are refreshing when the Master/Child Link Fields (SellerNumber) changes.
Does anyone have any insight on how I can explicitly force a pivot table refresh/requery when a change in SellerNumber occurs?
Thanks so much for your help
I am using MS Access 2003
I have used a Pivot Table 11.0 Active X object within eight subreports that are linked to a Main Report using the same Master/Child Link Field: SellerNumber
I am trying to find a way to use VBA to refresh several subreports within a Main report which each contain an Microsoft Office PivotTable 11.0 component. The Master and Child Link Fields for the Main Report are "SellerNumber".
I have written vba code in a module which will open a MS Access Report and iterate through a list of Account Reps generating one *.snp file containing all of the seller reports for a given account rep. This code generates the *.snp file without a hitch. However, none of the pivot tables contained withn the Main report's subreports are refreshing when the Master/Child Link Fields (SellerNumber) changes.
Does anyone have any insight on how I can explicitly force a pivot table refresh/requery when a change in SellerNumber occurs?
Thanks so much for your help
