Update A Chart In An Unbound Object Frame

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have an unbound object frame on a subreport containing a chart linked to a
chart in an Excel worksheet. I can open the subreport in design view, select the
unbound frame, go to Edit - OLE/DDE Links, click on Links in the dialog that
appears and click on the Update Now button and the chart updates.

Can the above be done programatically at runtime?

Can the above be done programatically before the subreport opens?

Thanks!

Tom
 
Just a guess, but, see if there is a Runcommand constant for this. (I don't
have Access here to check.)

HTH,
TC
 
Hi Tom,

Check out the Action property and acOLEUpdate constant of the
ObjectFrame control; also, perhaps, the ObjectVerbs and Verb properties.

AFAIK you can't do anything before the subreport opens (because it's not
there to do it to<g>), but I think you'll find that the Format event of
the relevant section of the subreport runs at a suitable time.
 
Back
Top