Previous Task and Next Task buttons aren't working

Hello,

I am have the attached worksheet and userform. I am looking to get the Previous Task and Next Task command buttons functioning properly. At the moment, when I hit them, they clear all of the text/combo boxes. I will also add the code to the bottom of this post for convenience. I guess I must add that when the Current Status has been updated to Complete, it copies that row, deletes it, and pastes it to the next available row on the Completed Tasks sheet. Not sure if that will have any factor.

CSI Team Maintenance Tasks.xlsm

Code for the userform:

Please Login or Register  to view this content.