In testing this userform template, I've encountered an "undocumented feature" that has me stumped.

If I use the form to view an existing record (using the navigation buttons on the form) and edit any field other than the Craft listbox, the Craft listbox value seems to disappear when I click on the Save button. If I click Cancel, the clean value from the datasheet is successfully retrieved again. Until I make a new selection in the Craft listbox, however, the same thing keeps happening every time I try to save after editing another field. If I make a new selection in the Craft listbox, I can successfully save the edits to the datasheet. This issue only seems to occur on the first record I edit. Once I have successfully saved one record (either a new record, or an edited record that I have re-selected the Craft item), everything works fine. I can edit other existing records (or that same one) without any issues.

To sum up:
First attempt to edit existing records after opening file -> Craft list selection disappears when Save button clicked -> must make new Craft selection in order to save edits OR must create and save a new record before attempting to edit existing records.

I've been searching through all the code, but can't find anything that seems to explain it (although, in fairness, I am pretty new to VBA). Does anyone else know why this would be happening? File attached below:

worklogv3.2.1.xlsm