View Single Post
  #1  
Old July 25th, 2007, 12:48 PM posted to microsoft.public.access.reports
Elena
external usenet poster
 
Posts: 105
Default modify data source of an oleunbound (excel chart) in access report

Hi

I have included in my access report a chart created in excel

I need to update the source data of this char on the On Open Event of the
Report

OLEUnbound39.Sheets(1).Range("B1")Value=.... brings the error " Object
does not support this property"

Yet, this error appears only if I use this code on thr On Open Event of the
Report, whereas if refer to the report and its oleunbound object from a form
for example the code works alright

Any suggestions?