Good Afternoon all,
I have a form that has control buttons on it to open reports, and I want to add into the VBA so that based on a check box on the form certain text boxes on the report are shown or not.
Currently I have:
Private Sub Command0_Click()
If Me.Check1 = False Then
DoCmd.OpenReport "ReportRecallRoster", acViewPreview
Else
DoCmd.OpenReport "ReportRecallRoster", acViewPreview
End If
End Sub
I am not sure what to add into the sections to control if a text box is shown, also I am not sure if it goes on the report or the form either any help would be great
Thanks
Marty