Charts not Updating when I scroll through Report

[AccessUser207]

I have a Report that has a Chart at the bottom of each page. When I scroll through my report, several pages long, I see that the report sometime does not update. Is there a way to force my chart to refresh???

 

[dhookom]

ACG Soft at

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

has some tips on charts in reports.

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]

 

[AccessUser207]

I need to have a macro called on the "on print" option in properties but I do not know how to build a macro. I am familiar with Excel VB, but the macro design view is confusing, it looks like I can only select drop downs from the action column heading. How do you build a simple macro for a first time user?

 

[dhookom]

You don't use a macro. You use VBA. Select "Event Procedure" from the drop down by the On Print event of the section of your report containing the chart control.

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]