The preview of my chart report doesn´t show the correct chart sometime

[ingp]

I have a chart report on Microsoft Access. There are many graphs, but they are grouped by a field. The preview doesn´t show the correct chart for each category always. I mean sometimes it does, but sometimes it doesn´t. If I print the report (PDF or printer) it shows different graphs also sometimes.
I thought it could be a memory problem of my PC, but I tried this on another PC with more memory, and the same happened.
I installed MSAccess again and this is still happening.
Does someone know a posible reason of why is this happening? What can I do to fix this?
I´ll appreciate any help with this......

 

[dhookom]

I assume you are using Access 2000 or later. This might be resolved using a little code in the On Format event of the section of the report containing the graph control. Try:

Dim obj As Object
Set obj = Me.grfMyGraph
obj.Requery
Set obj = Nothing
Replace "grfMyGraph" with your graph's name.

Duane
MS Access MVP

 

[ingp]

Excelent! Thank you very much.......
I did what you suggest me to do......and (for now) it´s working perfect........