Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2007-03-20
4
1,701 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

789 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