Subreport visible property

[ken]

Hi,
Why can't I do this in the report activate section of my main report?
I have a main report, and a subreport on it. The idea is that if the
subreport has a certain value in a control within it, I want to hide
the subreport. I get an error(runtime 2101 the setting you entered
isn't valid for this property) for the line of code below

Private Sub Report_Activate()
If Reports![Main Report]!Subreport!Value = 0 Then
Me.Subreport.Report.Visible = False
Else
Me.Subreport.Report.Visible = False
End If
End Sub

[Allen Browne]

You could put the subreport into its own section in the main report, and
hide that section if needed. Or you could use the Format event of the Detail
section of the subreport to set the Visible property of the section (or
toggle its PrintSection and MoveLayout properties.)

But a *far* better idea would be to create the source query for this report
with criteria so that these values don't show up.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ken" <ge****@gmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...

Hi,
Why can't I do this in the report activate section of my main report?
I have a main report, and a subreport on it. The idea is that if the
subreport has a certain value in a control within it, I want to hide
the subreport. I get an error(runtime 2101 the setting you entered
isn't valid for this property) for the line of code below

Private Sub Report_Activate()
If Reports![Main Report]!Subreport!Value = 0 Then
Me.Subreport.Report.Visible = False
Else
Me.Subreport.Report.Visible = False
End If
End Sub

[ken]

Hi,
Thanks for your reply Allen,
I don't understand what you mean by
"But a *far* better idea would be to create the source query for this
report
with criteria so that these values don't show up."

I have a query that I use for this report...? In very rare cases this
query will have data, but not in certain columns which the report
reads. In this case I get a blank report except for the report Title in
the header and a subtitle in the detail section. I have a way to test
for the above scenario, and would like to make the header or the whole
report invisible...but so far no luck at manipulating the visible
property for the report or the header/detail sections.

Thanks

[Allen Browne]

What are the conditions when you want the subreport to be invisible?

Could those conditions become the WHERE clause of the source query, so that
there is no data to show in the subreport? If so, that will solve the
problem, because the subreport does not print at all for those related
records that have no data.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ken" <ge****@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi,
Thanks for your reply Allen,
I don't understand what you mean by
"But a *far* better idea would be to create the source query for this
report
with criteria so that these values don't show up."

I have a query that I use for this report...? In very rare cases this
query will have data, but not in certain columns which the report
reads. In this case I get a blank report except for the report Title in
the header and a subtitle in the detail section. I have a way to test
for the above scenario, and would like to make the header or the whole
report invisible...but so far no luck at manipulating the visible
property for the report or the header/detail sections.

Thanks

[ken]

no, I have 3 text fields along with 5 yes/no columns which when all
are false, the report needs to disappear...
so unfortunately I can't solve the problem this way.

[Allen Browne]

So, in the query that supplies records to the subreport, include something
like this in the WHERE clause:
WHERE (([YesNo1] = True) OR ([YesNo2] = True) OR ([YesNo3] = True) OR
([YesNo4] = True) OR ([YesNo5] = True))

The records then disappear if all 5 yes/no fields are unchecked.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ken" <ge****@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

no, I have 3 text fields along with 5 yes/no columns which when all
are false, the report needs to disappear...
so unfortunately I can't solve the problem this way.