Subform NOT working in REPORT

[Gilberto]

Hello,

I have a form with some code to HIDE textboxes and labels when information is not used. I need this information in a report so i added the form as a Subform/Subreport in a report. The problem is that when runing the REPORT, it seems like the SUBFORM CODE DOESNT WORK, as it displays EVERYTHING. Its not following the code to HIDE the textboxes and labels, which are correctly hidden when running the FORM on its own.

Whats happening, what can i do??

Code lines in the form look like:

If IsNull([level7label]) Then
Me.Label166.Visible = False
Me.Label164.Visible = False
Me.Label165.Visible = False
Me.y16.Visible = False
 

Thanks,
Gilberto

[Rabbit]

Make a subreport and use the On Render event of the section that the information is in.

[Gilberto]

Make a subreport and use the On Render event of the section that the information is in.

Hello, thnks for the reply.

Just to be clear this is the situaction:

I simly dragged the form into the reports detail section, this section DOESNT have any ON RENDER event (it has on format, print, retreat), i actually COULDT find any ON RENDER on any section of or actual report. On the form i just inserted i found a BEFORE RENDER, AFTER RENDER and AFTER FINAL RENDER. The formatting code (if isnull([text1]...) i need is currently in the forms On Load so i simply did a copy paste into all of the render events however in the report the form (subform) code doesnt work.

Maybe i didnt understand what u were saying.

Any ideas???

Thanks

[FishVal]

Hi, Gilberto.

Rabbit obviously has dispelled event name.
Try OnPrint event on the main report.
And using subform control is quite acceptable in this case.

Be sure to refer to subform's control in a proper way.
e.g.

Me![Subform control name].Form![Subform's control name]
 

[Gilberto]

Hi, Gilberto.

Rabbit obviously has dispelled event name.
Try OnPrint event on the main report.
And using subform control is quite acceptable in this case.

Be sure to refer to subform's control in a proper way.
e.g.

Me![Subform control name].Form![Subform's control name]
 

Thanks, it worked perfectly.

[Rabbit]

Hi, Gilberto.

Rabbit obviously has dispelled event name.
Try OnPrint event on the main report.
And using subform control is quite acceptable in this case.

Be sure to refer to subform's control in a proper way.
e.g.

Me![Subform control name].Form![Subform's control name]
 

Yeah, sorry about that. I always think that there's an On Render event.