Access 2007 Graph update problems

[Troy]

I am using a subform and a main form. The subform contains fields which should update a graph on the main form. However I find this only works if I click on the graph. I have tried using refresh and requery on the graph itself, but nothing works. Apparently this is a common problem with this version of Access. I have the latest service pack installed also, but this has not resolved the issue.

Any ideas or code appreciated.

Thanks

 

[Gkirkup]

Troy: Did you ever resolve the 'graph does not display' problem. I am having the same problem.

Robert

 

[GinaWhipp]

Try putting a Me.Requery on the Graph click event and then

Call MyGraph_Click

on the After_Update of the fields.

 

[Gkirkup]

Gina:
Thanks. That looks as though it might work. I am not clear on 'Call MyGraph_Click' though. Do you mean substitute my graph name, as in Call Graph16_Click?
Also, my graph is on a subform, though I can put it on the main form. I have controls on another subform. Should I put Call Graph16_Click on one of those controls? Or something like Call me.parent.Graph16_click?

Robert

 

[GinaWhipp]

Yes that is what I meant as in your prior post I did not know the name of your graph. And, yes you are correct... I missed that whole subform thing.

 

[Gkirkup]

That didn't work. I tried several options.
I notice that there seem to be two copies of the graph. When closing the form, the top one goes away and for a second displays a second copy underneath, with a different alignment.

Robert

 

[GinaWhipp]

Did you place two graphs on the form?

 

[Gkirkup]

Gina:
No, just one graph. But there seems to be one graph under the other. If I add the record controls to the form (next record etc), hitting the 'last record' button will display the graph, same as double clicking the graph.

Robert

 

[GinaWhipp]

Try putting a DoCmd.Save before the Me.Requery event in the On_Click of the Graph as it sounds like it is not saving before requerying.

 

[ChrisO]

Did you try what I mentioned in this thread under the heading of Biggest Problem?

Chris.