Count checked checkboxes


On my MS Access form I'm creating an Unbound textbox which I'd like to count the number of check boxes selected in a subform (default view "DataSheet"). I thought if I do =Sum([table].[checkbox])*-1 would work, but that is not the case.

how can I accomplish this?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You have to query the record and COUNT the checkboxes that = true (or not zero).

Scott C
This should work behind am event handler:

    Dim ctl As Control
    Dim i As Integer
    i = 0
    For Each ctl In Me.YourSubFormName.Controls
        If ctl.ControlType = 106 Then 'The control is a checkbox
            If Nz(ctl.Value, 0) = -1 Then 'do not evaluate null or unchecked
                i = i + 1
            End If
        End If
    Debug.Print i <------Use this however you need it

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Im not sure this will work for the Datasheet view...but this is what I would do in a regular form.

Dim ctl As Control
Dim intCount As Integer
intCount = 0

For Each ctl In Controls

If TypeOf ctl Is CheckBox Then
    If ctl.Value = -1 Then
        intCount = intCount + 1
    End If
End If


MsgBox intCount
AIdoHSGAuthor Commented:
Thank you all... I managed to get it to work.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.