F
Floyd Forbes
how do you count the number of "yes" check boxes on a form?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Chris Darnell
Here is a code snippet that should point you in the right direction:
Dim i As Integer
Dim objControl As Control
For i = 0 To Me.Controls.Count - 1
Set objControl = Me.Controls.Item(i)
If (objControl.ControlType = acCheckBox) Then
Debug.Print objControl.Value
End If
Set objControl = Nothing
Next
Hope that helps!
Chris Darnell
http://www.darnellc.com
Dim i As Integer
Dim objControl As Control
For i = 0 To Me.Controls.Count - 1
Set objControl = Me.Controls.Item(i)
If (objControl.ControlType = acCheckBox) Then
Debug.Print objControl.Value
End If
Set objControl = Nothing
Next
Hope that helps!
Chris Darnell
http://www.darnellc.com