Pat,
1. I moved the code to the AfterUpdate event. (Previously, the AfterUpdate event was just calling the Change event!)
2. However, the subform recordsource is originally qryfrmDenTrackingActionNeededAll. It is changed to qryfrmDenTrackingActionNeeded. So I kept the change to the...