Judith, this one is MY FAULT. The problem is that I didn't correctly show you how to use the CONDITION column in the macro builder. See, just like I said in the video, I almost NEVER use macros. I use VBA programming for almost everything (especially something this easy). And, unfortunately, I didn't test this thoroughly enough in class to notice this problem - which is why this user feedback interaction is so cool.

Anyhow, here's what happened... I forgot to tell you that you either need to copy the conditional statement down to the NEXT ROW for each item that is supposed to run UNDER it, *OR* use an ELIPSIS to indicate that the current condition runs as part of the previous one.

So, what's happening right now, is the first condition runs, which is [RecurringCombo]=1 and it performs its SetValue command if that is the case, but then the NEXT line runs REGARDLESS OF THE CONDITION because it has no condition. So in ANY CASE, the value of the Completed checkbox is made FALSE.

How to fix it? Either copy the condition down from the previous line, or just put a ELIPSES (...) there to indicate it's part of a "BLOCK" of statements.

I'll make sure to make this change to the video the next time I edit the class, but I'm very happy you found this problem. This is a MAJOR booboo on my part. I really haven't done anything in any of my personal projects with Macros in YEARS (again, all VBA), so that's why I didn't catch it. As soon as you mentioned this was happening, I was like "uh oh... my bad."  :)  I'm just sorry I didn't get to this sooner. I've been so busy I haven't had a chance to go through my Blog posts in a long while.