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.
On Thu, 18 Sep 2003 14:36:28 GMT, "Tom" <th*******@earthlink.net> wrote:
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
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.