assigning a value to the control on a subreport (simple syntax ?)

[markjkubicki]

need to assign a value to the control on a subreport; but... I'm stuck in syntax
the report name is rptFixtureSchedule_working copy
the container on it for the subreport is ctr_Col1
the subreport is srpt_FixtSched_col1
the control on it is txtCol1_Text_001

the code I'm fighting with is (and the many variations of....):

        
Reports![rptFixtureSchedule_working copy].report![ctr_Col1].[srpt_FixtSched_col1].[txtCol1_Text001] = strManufacturer

with thanks in advance...
mark

[pbaldy]

Same as forms but with Reports/Report:

http://www.theaccessweb.com/forms/frm0031.htm

[markjkubicki]

Thank you for the reply
I do know of the table and have referenced it MANY times
But this time I just can't get it right?

=:-(

[pbaldy]

Table? Did you look at the link? You don't reference both the subreport container and the subreport, just the container.

[June7]

Reports![rptFixtureSchedule_working copy].[ctr_Col1]![txtCol1_Text001] = strManufacturer

Won't work if report is in PrintPreview or direct to printer. Has to be ReportView.

Where is the code executed? How is strManufacturer populated?

Probably should have [txtCol1_Text001] ControlSource reference a control on form or call a user defined function.