Dear Rick,
I have followed the Work Order Seminar to Lesson 19 with no problems.  
However, the Triple State Check Box in Lesson 19 does not work on Access 2010 running on Windows 7.
The check box works in dual state, and if I rem out the two SQL statements in dual state, I get the desired result - (Closed Works Orders) and (All Works Orders) - so the code is clearly correct, but if I retain the triple state I only see the Open Works Orders and cannot change the box of the text box to a tick or check!
However if I run exactly the same program on my Windows 7 laptop running Access 2007 all the code works as intended.
It seems there is a bug in the Access 2010 program.
Can you confirm that?
Regards
David