VBA Form to Report Conditional

[M.Enders]

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

[pbaldy]

To affect visibility it would go on the report. Presuming you leave the form open, code in the format event of the section containing the controls:

If Forms!FormName.Check1 = False Then
  Me.TextboxName.Visible = False
Else
  Me.TextboxName.Visible = True
End If

Someone would invariably chime in with this, which is shorter but confusing to beginners:

Me.TextboxName.Visible = Forms!FormName.Check1

[pbaldy]

Oh, and if you didn't want to leave the form open, you could pass True/False to the report in OpenArgs and use that.