hiding subreport in vba

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can i use the subproperties.visible in a subreport

i want it to be visible only in a given situation. but when there is no visible subproperties when i'm coding the program. help please.

subspin is my subreport

subspin.visible = true is not allowed how can i correct this
 
Make the subreport visible or invisible using code in the main report. In
the OnFormat event of the section of the main report in which the subreport
is located:

Private Sub Detail_Format()
If "X" = True Then
Me.subspin.Visible = True
Else
Me.subspin.Visible = False
End If

The above assumes that subspin is the name of the control that holds the
subreport, which may or may not be the name of the report that is being used
as the subreport.


--

Ken Snell
<MS ACCESS MVP>

dimwit said:
how can i use the subproperties.visible in a subreport

i want it to be visible only in a given situation. but when there is no
Click to expand...
visible subproperties when i'm coding the program. help please.
 
Back
Top