Has the record been explicitly saved? Try adding Me.Dirty = false before your docmd.openform.
We probably need more info to answer your question.
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
Hi
It would be a lot easier if you can upload a zipped copy of the database with no confidential data.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description