Solved

Pivot table and Chart fails to refresh in Microsoft Access 2003 form

Posted on 2007-03-20
4
1,704 Views
Last Modified: 2013-11-28
How do I refresh a access pivot chart and pivot table on the same form by vba?
I have an access 2003 form which contains a series of combo boxes allowing a user to filter the data they would like viewed in a graph and pivot table for analysis.  I have tried a requery command through vba to have the chart and table refresh, it fails to do so. Can someone give me a hand with this.
0
Comment
Question by:nzbeaston
4 Comments
 
LVL 38

Expert Comment

by:puppydogbuddy
ID: 18762070
Whether the requery works or not often depends on the timing (event) and the object reference used for the object that the requery method is executed for. Also, assumed that the pivot table and chart are just on a form, and not on a subform, correct?  You did not post your code, so it is difficult for any expert to help you. .
0
 

Author Comment

by:nzbeaston
ID: 18797526
Thanks for the feedback. Sorry about the delay I have been away.

I've managed to correct the problem which was a piece of code looking at the wrong control.  I had a unbound combo box called "Contractor", the pivot table embedded in the form was looking at the Contractor ID as the Link child and parent fields. As the whole form had an underlying record source of a Contractor Table - the pivot would only update when I moved to the next record. I was attempting to move to the next record through the unbound control which is what I wanted. Once I updated the link child and parent fields to the unbound control and used the requery command the pivot chart and table would refresh. Thanks for your opinion and I will post better code next time.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 21130191
PAQed with points refunded (50)

Computer101
EE Admin
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question