Changing the visible setting for a field in a sub report

[Bill]

I have a command button that opens the a report. On the report the
bulk of the information is in the sub report. I have a check box on
the form that if isn't check will cause a field to be invisible on the
report. I want to be able to set the corresponding field on the sub
report the same way. I can't seem to get the syntax right to change
the visible value in the sub report. Right now I'm using "Reports!
rpt_top_user!rpt_top_user_sub!ts_opname.Visible = False" and the I get
an error saying that if can't find the field "rpt_top_user_sub". Any
ideas??

[storrboy]

I think the normal breakdown is:
Main Report Sub Report Control Name.Report >Sub Report Control Name

Reports!rpt_top_user!rpt_top_user_sub.Report!ts_op name.Visible = False
where rpt_top_user_sub is the name of the subreport control, not the
name of the report in it.

Where are you using this statement by the way?

[paii, Ron]

I believe you can use the "Parent" property in a sub report. In the onFormat
event of the subreport use Me.Parent to check the value of your check box
and set the control's visibility.

"Bill" <wl*********@gmail.comwrote in message
news:11**********************@l75g2000hse.googlegr oups.com...

I have a command button that opens the a report. On the report the
bulk of the information is in the sub report. I have a check box on
the form that if isn't check will cause a field to be invisible on the
report. I want to be able to set the corresponding field on the sub
report the same way. I can't seem to get the syntax right to change
the visible value in the sub report. Right now I'm using "Reports!
rpt_top_user!rpt_top_user_sub!ts_opname.Visible = False" and the I get
an error saying that if can't find the field "rpt_top_user_sub". Any
ideas??

[Bill]

On Mar 19, 6:07 pm, "storrboy" <[e-mail]:

I think the normal breakdown is:
Main Report Sub Report Control Name.Report >Sub Report Control Name

Reports!rpt_top_user!rpt_top_user_sub.Report!ts_op name.Visible = False
where rpt_top_user_sub is the name of the subreport control, not the
name of the report in it.

Where are you using this statement by the way?

I'm using this statement for the "on click" of the command button. It
comes right after the statement is issued to open the report

[Bill]

Using "Reports!rpt_top_user!rpt_top_user_sub.Report!ts_o pname.Visible
= False" did the trick.

Thanks for the help.