Hi all,
My basic question is: Why won't my graph update?
My less basic question is:
I have an access form with a MS Graph 2000 chart object on it. The chart object has a SQL Pass-through query as a row source. The query gets its data from two SQL tables.
I have a button on the form that runs a bunch of VBA code that, among other things, updates/inserts a row in one of the tables the query uses. I want my chart to update and show this new row as soon as this change is made - so I used MyForm.MyGraph.Requery in the code, but it did nothing.
I know the new row exists: While testing I put a subform on the form that displayed all rows of the graph's source query so I could see if the same thing happens to any display of this particular query - the subform updates automatically exactly when I expect it to, without me having to requery it but the graph doesn't. I'm sure I'm requerying the right graph object. The graph will refresh to show the new value when I move the form window, scroll my scroll wheel, click on the form or set a breakpoint and step through the code, but not when I call Requery.
The chart object's set to update automatically, and calling MyForm.MyGraph.Refresh instead of Requery makes the chart go blank (no axes, labels, etc).
Does anyone have any ideas on what I might be missing?
Cheers in advance
- LMF