up date chart

[amna77]

Hi, i have one chart in my report, created that from chart wizad and based on date from table. the thing is when i open the report, chart does not refresh with new data. i have to close and open report 2, 3 times in order to refresh. what should i do to refresh, and how?
thanks

 

[dhookom]

From ACG's web site

http://ourworld.compuserve.com/homepages/attac-cg/

Add the following Visual Basic code to the On Print event of the section of the report that contains the Graph object.


On Error Resume Next
Dim objGraph As Object
Set objGraph = Me!TheNameOfYourGraph.Object
objGraph.Refresh
DoEvents
Set objGraph = Nothing


Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]