I am trying to set-up a printable version of graphic charts and have set-up the report and can successfully change the chart title that displays by changing the caption property of the label field. All charts are driven off the same data table and I have a subform (continuous form) that displays the data for each of the chart variables. I want to change the labels on this subform based on the data that is displayed but I can't figure out how to do it. Here are some particulars:
data table = tbl_MData
Report = rpt_4DataSet
subform with data table in it = subprt_4Data
Report subform control where subform is displayed = Reports![rpt_4DataSet]![Legend]
There are 4 Label Controls in the subform header called:
I want to change the .Caption of these four Label controls to identify the data being displayed. From the form that calls the report (as a print preview) I tried the following:
Forms![subprt_4Data]![Label_Month].Caption = strArrDataType(0)
I get the following error:
Run-time error '2445':
You Entered an expression that has an invalid reference to the property Form/Report.
I also tried:
Reports![rpt_4DataSet]![Legend].Form![Label_Data1].Caption = strArrDataType(0)
which does not give an error message but it does not display anything either.
Edited by: traveler on Thu Feb 22 12:33:17 EST 2007.