Ian Leason
asked on
Access 2003 graph not refreshing after changing data
Hi, hopefully someone will be able to help me with the following:
I am using Access 2003 and have inserted a graph (from the Insert menu) on a form. The data for the graph is user selectable via a combo box on the form. This works fine except for refreshing the display.
I am using the code (Me.graPlan.Requery) in the update of the combo. But, I still have to manually click the graph and then another control on the screen to force the graph to display.
Any help with this is greatly appreciated. Thanx in advance!
I am using Access 2003 and have inserted a graph (from the Insert menu) on a form. The data for the graph is user selectable via a combo box on the form. This works fine except for refreshing the display.
I am using the code (Me.graPlan.Requery) in the update of the combo. But, I still have to manually click the graph and then another control on the screen to force the graph to display.
Any help with this is greatly appreciated. Thanx in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Strange, try a Me.Repaint.
If that doesn't work, would you be able to upload a copy with just that problem form?
If that doesn't work, would you be able to upload a copy with just that problem form?
ASKER
Please find an example db attached. With this when you open the form you have to click the button to make the graph display - this is the same behaviour I am experiencing. Hope that makes sense.
db1.mdb
db1.mdb
Put a Me.Refresh in the form's OnLoad event. This should show your graph as soon as you open your form.
Use refresh as well when the underlying data changes.
Use refresh as well when the underlying data changes.
ASKER
Me.Refresh doesn't make any difference, the graph still only refreshes after clicking another control on the form
Unfortunately I don't have 2003 installed. I was trying this out on 2007 and it works fine. Let me see if I can get some other experts to chime in.
ASKER
Thank you :)
This sample might not accurately show the problem you are having in your database.
I just tested it in Access 2003, and the chart definitely displays when you open the form. There is a brief delay as it is loading where the chart appears blank/white, but after a second or so the data is displayed.
There is no combo box with which to test/troubleshoot the problem you described in the original question.
I just tested it in Access 2003, and the chart definitely displays when you open the form. There is a brief delay as it is loading where the chart appears blank/white, but after a second or so the data is displayed.
There is no combo box with which to test/troubleshoot the problem you described in the original question.
ASKER
After reading your comment I got out my old laptop which has Windows XP on it and for some reason it works perfectly on there - graphs in both the sample and my original database work correctly. It just doesn't work correctly on my Windows 7 machine, I am assuming this could be due to something I have installed - that is the only explanation I can think of. Luckily even though I am developing the database on my Windows 7 laptop, it will not be used on there.
Thank you for your help, I will award the points to IrogSinta as his answer was correct, for some reason my laptop does not appear to work correctly with the graphs - I have so much installed identifying the problem program would be very difficult.
Thank you both again for your help.
Thank you for your help, I will award the points to IrogSinta as his answer was correct, for some reason my laptop does not appear to work correctly with the graphs - I have so much installed identifying the problem program would be very difficult.
Thank you both again for your help.
ASKER
I can tell it is refreshing (or requerying) but it just will not display the graph until I manually click the graph and then click any other control on screen.