Refresh MS Access Charts

Posted on 2009-04-24
Last Modified: 2013-11-28

I built a form that is acting as a dashboard displaying data in a series of subforms. one subforms is called assignedIds and another is displays a chart based on the number of Ids that are updated... currenlty whenever a user updates data in the assignedIds subform in the DateUpdate the other subform called charts isn't updating... how do i update a chart from another subform when a particular field changes?
Question by:AIdoHSG
    LVL 7

    Accepted Solution

    You can do a requery to the subform holding the chart in the AfterUpdateEvent of the subform the user changes data with


    Or you can update the chart with


    Author Closing Comment

    thank you... it worked

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now