Count control

  • Thread starter Thread starter Jeff G
  • Start date Start date
J

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
 
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
 
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
Click to expand...


.
Click to expand...
 
Back
Top