Counting True Checkbox on Form

[SpiritedAway]

Hi.

I have a continuous form with a bound checkbox [VAT] - I have an unbound textbox which I want to use to count how many checkboxes that are TRUE.

I'm trying to use the =Count function but getting invalid syntax error messages.

Could anyone advise the correct syntax to use as the control source for the textbox.

Thanks for your help.

Using A2007

 

[vbaInet]

Something like this:

=Count(IIF(Nz([[COLOR=Red]Field[/COLOR]], 0) = -1, 1, Null))

 

[SpiritedAway]

Brilliant!! - thanks once again vbaInet for your invaluable help!

 

[vbaInet]

You're welcome!