Parry IT Support

To change a subreport visible control. This will either show or hide a sub report on the main report depending on the value set.

Set variable as public in a module

        Public StrVisibleView As String

ON THE FORM SELECT FORM

    Use a combo box (Called SELECTBRAND) to select JMB or BT off form select page

    When button to print

On click

    StrVisibleView = SELECTBRAND

ON THE REPORT

'' Make sure you set the default visible setting on each sub report to NO

    Private Sub Report_Open(Cancel As Integer)

            If StrVisibleView = "JMB" Then

                Me.RptLogoJMB.Visible = True

                Me.RptLogoBT.Visible = False

            End If

            If StrVisibleView = "BT" Then

                Me.RptLogoJMB.Visible = False

                Me.RptLogoBT.Visible = True

            End If

            MsgBox "Your are using the " & StrVisibleView & " brand", vbInformation

            StrVisibleView = "1" 'RESETS THE VARIABLE (Can be any value apart from the two set in SELECTBRAND

End Sub

Links

https://www.access-programmers.co.uk/forums/threads/hide-subreport-if-it-has-no-data.212478/