invalid reference to subreport 1

[stupiet]

In VB I'm trying to reference fields in my subreport but for some reason it will not recognize this reference.

Here's the reference I wrote:

Reports!MainReport!SubReport.Report!Field1.Visible = False

When runinng this script I get the following error:

Run time error '2455':
You entered an expression that has an invalid reference to the property Form/Report.

Aren't I using the right reference? Please help! Thanks

 

[dhookom]

Where is this code running? Is there other code in the module that you could share with us?

Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[stupiet]

It won't even work if it is used as follows:

Private Sub Report_Open(cancel As Integer)

Reports!MainReportName!SubReportName.Report!Field1.Visible = False

End Sub

 

[dhookom]

Where is the subreport located? I would try place the code in the On Format event to the section of the main report that contains the subreport:

 Me.SubReportName.Report!Field1.Visible = False

It would make more sense to me to run the code in the On Format event of the section of the subreport that contains "Field1".



Duane MS Access MVP
Now help me support United Cerebral Palsy

 

[stupiet]

You are right! I guess it does not know the field exists yet when you use it in the Open Event.

Appreciate the help!