Your form load code doesn't make sense. If you're at BOF, you can't move previous, nor can you update a recordset unless you put it in edit 'mode'. In your code, there is nothing to 'save' in the recordset because you don't make any changes to it anyway.
Otherwise, button code fired for me, so make sure db is in a Trusted Location.
What do you want to save? You don't save record changes this way - only object changes such as forms/reports design or code edits.
Last edited by Micron; 09-13-2021 at 05:07 PM.
Reason: added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.