If all records completed = true

[lloydmav]

I will have a query which sets a criteria from a table.

Now on an onclick procedure I want something that will say,
If all the records in the query have a field called "Completed" = True selected then I will do so and so.

The "Completed" field is a checkbox, so if all those records in the query have there checkbox ticked I want to do something.

How do I check this?

Thanks

 

[Jon K]

Try this:-

If DCount("*", "QueryName") > 0 And (DCount("*", "QueryName") = DCount("*", "QueryName", "[Completed]")) then

......

End If

 

[lloydmav]

Bingo!

That works!

Thanks Alot, your help was much appreciated!