counting check boxes (Yes / No)

[totolkhan]

hi guys
i have 2 questions
1.
how can i count selected or not selected checkbox fields (yes/No) in a tex box ?!
( for example we have a 2 yes/no fields that are Male and another Female , and i want to make a form that shows number of males and number of females that selected in a text box )

2.
how can i make a search form that when i chose check boxes and then Search button it will show me the list of selected checkbox that selected in main form

( for example if we have 3 checkboxes 1.(low) 2.(mid) 3.(high) in main database and form , and if i want to make a search form that shows me list of enterees that is (Mid) )

thanks alot

 

[ansentry]

To count ticks on a continious form:

Put an unbound text box in the form footer and enter this

=Abs(Sum([RED]))

Change RED to the name of your check box.

 

[totolkhan]

thanks , but what about second question

 

[ansentry]

Have a look at the attached sample, simple but works

 

[totolkhan]

i don't know how to thank you dear john ,
you are amazing ,
thanks

 

[ansentry]

All we all need is a:-

"Thank You"


(Just like you did)

 

[totolkhan]

dear john
i have another question !

in your example after that i push the button (all lows) it will shows the list of all selected lows , now if i want to double click on a person and then shows another personal form and goes to that persons information what ?!
thanks

 

[ansentry]

Have a look at the attach sample etc.

See if this is what you want.

Good Luck

 

[totolkhan]

you are the best !
lots of thanks again
that's exactly what i'm looking for ,
thanks dear john