Set Control Source Value in SubReport at Runtime from MainReport

[BobVezz]

I have a report and a sub-report. I want to reuse the sub-report in the main report, but change the Control Source of a TextBox for each use. I am coding:

Reports![rptMain]![SubReportControlName].Report![Title Label].ControlSource = "=""Value A"""

I consistently get:

Run-time Error 2455 You entered an expression that has an invalid reference to the property Form/Report.

The code is in the Report Open event of the main report. What am I missing or not seeing?

Thanks
Bob

[Mihail]

What is Value A ? It seems to be a variable, but become a string in your code.
Try to debug that by slightly change your code:]

Dim NewControlSource As String
NewControlSource = "=""Value A"""
Debug.Print NewControlSource
Reports![rptMain]![SubReportControlName].Report![Title Label].ControlSource = NewControlSource

Of course you will obtain the same error message but now, when the code stop, you can see in Immediate window (press CTRL+G to open this window) that the value for your NewControlSource is all the time this string: ="Value A". And this not seems to be an SQL string.