I am encountering this consistently now, doing the same thing each time. I have a form that is opened by pushing a button on another form. In this case, a new record is created, then this form is opened and functions as an entry form for the new record. At this point, I am pressing the "Cancel" button on my new form (never mind, I don't want to add a new record), which executes a short procedure in the Procedure pane that first shows a message confirming that I am at that point, then it calls an external procedure that does only this:
It sometimes works as intended, but mostly today it actually appears to skip (or fail to execute) the DeleteRecord command and just closes the window (the newly called form). And when it does this, the new blank record in the main form remains showing, and it is locked up tight. Clicking in any editable field gets the error message about being locked by another user; navigation buttons do nothing and the delete record button does nothing. Trying to close the database gets me the choices about saving or reverting, but neither seems to do anything and it finally gives me the beachball forever.
I've done this sequence several times today with the same result, but just to complicate things I just did it again and even though it did all the things I just described, it did not lock up this time. And I was able to close it without incident.
And so I have had to Force Quit most times this happened, and I saved the entire text of the report in case anyone would like to see it.