Chart Problem

[rfear]

From searching this forum it will be no surprise to learn that I have some charts that are not updating reliably.

Even worse it's an intermittent fault, sometimes they do, sometimes they don't.

I have placed a requery command when the report opens, when the section containing the chart formats and when it prints and I still get issues. I've added a refresh command as well, except when the report opens.

I have not linked any child or master fields as this seems to produce a blank chart.

Is there anything else I can try to get my charts to update reliably ?

Most problems appear to happen when data is deleted or added to the underlying table. Then on first opening of the report the chart is not updated. I have to close the report and reopen it, then the chart is OK.

 

[rfear]

Even modifying the code to open the report twice hasn't helped.

I'm going to try building in a time delay. I saw somewhere that this might give the chart a chance to pick up on the query.