checkboxes in Access 2000

[samman]

I have a form with several checkboxes. I want to be able to check these checkboxes for the ones selected by the user and then run a certain report for the specific checkbox selected. I have about 20 checkboxes and would like an easy way of looping through these but don't know how. Please Help!

[peet]

Private Sub Command1_Click()
    Dim c As Control
    For Each c In Me
        If TypeOf c Is CheckBox Then
            Debug.Print c.Value
        End If
    Next c
End Sub

will that do ?