Access 207.2, TI 7:50 Using Access 2000.

When I create the Macro shown in the instruction, the "Not Recurring" Tasks do not get set to complete.

I found that in all cases of the value of RecurringCombo (0...6), the Macro executes all instances where we set the value of Completed to False. As well, through the execution of the macro, where the one condition line matches the value of RecurringCombo, this line will also exceute.

This means that when I click the completed checkbox on a task that is "Daily", I will run the condition where I change DueDate by one day; but I will also set Completed to False six (6) times as the macro progresses to the end.

In the case of where RecurringCombo equals "Non Recurring", there is no conditional match and so the due date cannot not get set - as expected; but the Completed value will get set - 6 times to false.

To make this work in my environment I slightly changed it as follows:

[RecurringCombo]=1   SetValue   Daily
...                  SetValue

For each "SetValue" where there is no condition defined and we set Completed to False, we need to add an ellipsis ("...") in the condition field to indicate that this action takes place if the same conditions defined above the ellipsis are satified. This way, SetValue of Completed to False only gets executed once, and in the case of RecurringCombo equals "Non Recurring", SetValue of Completed does not ever get executed. This allows the value of the check box to remain set to true.