a Zero outcome I assume means that the Employee level table should not be updated at all
You are correct..... I tried to run the code based on if frmRequirementsSubform txtCompletedInCompleteReq was a 0 dont run the code and if it was a 1 run it but something is goofy if you start deleting end entering dates in txtDateCompleted.

Yes I played with the recordset for a few hours last night and couldn't figure it out...