I have a report that includes several sub-reports. I would like the option to exclude one or more of the subreports. I have included a column in the table to record whether a checkbox on the applicable form is checked or not. If the form is checked and thus recorded in the table, the intent is to make the sub-report not visible. Each report and respective sub-reports are joined by a job code which is the key field. I'm using the following code:

Private Sub CheckExperience()
If (Forms!sfrmExperienceDataInput_Subform.CheckExperi ence) = False Then


Me.rptExperience_Subreport.Visible = No
End Sub

However, it won't work. I'm a newbie at this stuff so clearly I'm missing something. Any ideas? Thanks in advance.