Results 1 to 6 of 6
  1. #1
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84

    Chart doesn't update untill i close and reopen db

    Chart doesn't update untill i close and reopen db.

    Any help appreciated.



    Thanks,

    john

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Rather sparse on details! You need a "Requery" somewhere - after the data changes and when you want the chart to be updated would be the correct moment.

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Yep try to Requery, Repaint or Refresh the chart object or the form. Maybe in the AfterUpdate event on the chart form.

  4. #4
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84
    How do you requery?. Also if you need more details just let me know what you need. Thanks

  5. #5
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84
    And how do you do this automatically so after you enter data it updates without having to take action

  6. #6
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Not sure how your form is designed but go to Form Design on properties in the Event tab, in the AfterUpdate row, click on the button to open the code window and put:

    Forms!YourFornName!ChartName.Requery

    Change those names to your actual form and chartfield names. Your you might just need to do the form Requery.

    Forms!YourFornName.Requery

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 04-12-2014, 01:29 PM
  2. Replies: 4
    Last Post: 01-31-2014, 12:36 PM
  3. Replies: 4
    Last Post: 09-16-2013, 05:55 AM
  4. Replies: 4
    Last Post: 12-16-2010, 03:50 PM
  5. Chart doesn't show data
    By pbaxter in forum Forms
    Replies: 5
    Last Post: 01-20-2010, 11:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums