I have an access report that contains a pivot table/chart that is linked to an Oracle view.
When I change the data, the chart doesn't refresh.
I'm used to breaking down a task and programtically doing the steps
In this case, I am lost.

I manually do the following:
open the report in design mode
Rightclick on the object and pick Worksheet Object- edit
From the Pivot table control, pick the Refresh Data button
It then asks for the Service Name, UserName and Password for the Oracle ODBC connection
I then save the report.

The report is refreshed.
In the interest of driving the report generation and database via VBA in access, this step is critical.


Does anyone have any insight?

Thanks in advance....
Jerry