Link to home
Start Free TrialLog in
Avatar of Ian Leason
Ian LeasonFlag for United Kingdom of Great Britain and Northern Ireland

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!
ASKER CERTIFIED SOLUTION
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ian Leason

ASKER

Thanks for your comment, but it is exactly the same.

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.
Strange, try a Me.Repaint.  
If that doesn't work, would you be able to upload a copy with just that problem form?
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
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.
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.
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.
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.