Chart doesn't update untill i close and reopen db.
Any help appreciated.
Thanks,
john
Chart doesn't update untill i close and reopen db.
Any help appreciated.
Thanks,
john
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.
Yep try to Requery, Repaint or Refresh the chart object or the form. Maybe in the AfterUpdate event on the chart form.
How do you requery?. Also if you need more details just let me know what you need. Thanks
And how do you do this automatically so after you enter data it updates without having to take action
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