Count control

[Jeff G]

I would like to create a control that displays a count of
the number of yes/no check boxes checked with a yes (-1)
on a form. Also would like to have it update as a box is
checked. Also should only count the number of "-1" boxes
actually being displayed as th record set will be filtered
in the form. Now I have the control with the control
source property as:
=Count([Inspectionplan]= -1) where Inspectionplan" is the
name of the y/n feild for the checkbox. the control
displays the total number of filtered records diplayed
rather than the # checked.
Any suggestions?
Thanks Jeff G

 

[tina]

if you're talking about a Single form or Continuous form, with a single
checkbox control, and you want to count the number of records where that
checkbox is checkmarked, then try this:

put an unbound text control in the form's header or footer.
set the ControlSource of the text control as
=Sum(Abs([Checkbox]=-1))

hth

 

[Jeff G]

Thanks!

-----Original Message-----
if you're talking about a Single form or Continuous form, with a single
checkbox control, and you want to count the number of records where that
checkbox is checkmarked, then try this:

put an unbound text control in the form's header or footer.
set the ControlSource of the text control as
=Sum(Abs([Checkbox]=-1))

hth

I would like to create a control that displays a count of
the number of yes/no check boxes checked with a yes (-1)
on a form. Also would like to have it update as a box is
checked. Also should only count the number of "-1" boxes
actually being displayed as th record set will be filtered
in the form. Now I have the control with the control
source property as:
=Count([Inspectionplan]= -1) where Inspectionplan" is the
name of the y/n feild for the checkbox. the control
displays the total number of filtered records diplayed
rather than the # checked.
Any suggestions?
Thanks Jeff G

.