Count Check Box

  • Thread starter Thread starter mandy84angel
  • Start date Start date
M

mandy84angel

I have a form (F1) which has a section that lists three check boxes (EL,
Admin, Other). On another form (F2), is it possible to count how many of
those three checkboxes are checked on all records in F1?

In F1, there is another checkbox (Corrected) which I would also like to
count how many records are checked on F2 in a separate textbox.

Thank you for your time!
 
Create an unbound text box with this as the source
in the forms footer or header

=Sum(IIf([EL]=-1,1,0))+Sum(IIf([Admin]=-1,1,0))+Sum(IIf([Other]=-1,1,0))
 
Back
Top