I have a table that has 3 check box

[McWhorter]

I have a table that has 3 check boxes(A, B, C) along with a few other fields. The records could have any combination of A,B, or C checked or none at all.

I have created a form that has 3 unbound check boxes labeled (A, B, C).

Here is what I want to do.

A command box needs to be created that will check which boxes are checked and then open a report that will show all records that have been checked.

Any suggestions.

 

[VBslammer]

Do a simple For-Each loop:

Private Sub cmdOpen_Click()
Dim ctl As Control
For Each ctl In Me.Controls
If TypeOf ctl Is CheckBox Then
' look for specific control names, ex. chkFoo1, chkFoo2, chkFoo3...
If InStr(ctl.Name, "chkFoo&quot > 0 Then
' If checked...
If ctl.Value = True Then
'Get the tag property - which could be anything you want...
Debug.Print ctl.Tag
' do other stuff...
End If
End If
End If
Next ctl
End Sub

VBSlammer