How to hide subreport based on control in main report

[Josh330]

Hi everyone. I have been researching something for days and cannot seem to find the right answer. I have a report called Names. In that report is a combo box called Place. I have a subreport called Specs. I am trying to make the Specs subreport hidden based on Place being "USA". I have been able to get this to work using forms where I have successfully hidden a subform. I cannot seem to do it in reports. Can anyone suggest the proper VBA code? Thanks!
Josh

[June7]

What is your code? What event did you use?

Do you want this display dynamic for each record? Usually, code must be in Format or Print event of section subreport is in.

If you want to provide db for analysis, follow instructions at bottom of my post.

[Josh330]

Hi June. Below is the code I put into the On Load event of the main report. Nothing seems to happen - the Specs subreport is still visible.
Thanks.
And, yes, need it to be dynamic for each record.

Private Sub Report_Load()


If Reports!Name!Place = "USA" Then
Me.Specs.Visible = False
Else
Me.Specs.Visible = True
End If


End Sub

[June7]

Then try what I already suggested.

Subreport is in Detail section?

Is Specs name of subreport container?

Even if not visible, subreport still uses space.

[Josh330]

Your suggestion worked. I put the code in the On Format event of the Details section. In Print Preview the subreport Specs is now hidden. I tried the On Print event, but got a result that was a bit wonky. Thanks so much for your help!