Simple task but must be fast

[Colman]

I have a main form which includes a subform displaying items from a query. The subform items have a checkbox which the user ticks to indicate that that item has been inspected.

The simple task is to display a count of the number of items that have been ticked, on the main form. I did this by putting a set value and DCount statement in a macro on the checkbox after update property. This works but creates a delay for the user when ticking items. They need to be able to tick items rapidly at times.

I have seen an SQL statement using SELECT COUNT etc which looks like what I need but have no idea where to put the statement.

Can anyone help me out.

[rpeare]

D functions are not efficient

If your inspection is in fact a yes/no field it's values are stored as -1 and 0 for yes and no respectively.

you can sum the total inspect items by getting the absolute value of the sum of the yes no field. Let's say your field is actually called INSPECTED. Your formula would be

Abs(Sum(Inspected))

[Colman]

Thanks for responding.

Am I right to put this formula in a set value command in a macro on the checkbox 'after update' property, or is there a better way?

[rpeare]

Without knowing the setup of your form I couldn't say.

If the checkboxes are on your main form you can just have an unbound text box with the formula I gave you in it (preceded by a = sign). If the checkboxes are in a subform it would be different, let's say your subform was called subForm1 you'd have something like

=abs(sum(forms!mainform.subform!Inspected))

[Colman]

Thanks again. The checkboxes are in the subform.

Getting 'Error' in the unbound text box when I put the formula in it.

However, it works perfectly using a set value macro on an empty text box.

This is a result. Many thanks.