In the series of system messages that can be hard to interpret and not providing clear directions on how to handle next, here is one that I see occur regularly in NAV’s classic client: ‘Form X’ cannot be closed because it is locked by ‘Form Y’
Let me start by saying that this does NOT indicate that there was a table locking or any other type of lock by another user. This message is telling the user that it is trying to close a form but that form was used by that same user to open another form in Dynamics NAV which needs to be closed first.
In most cases when a user closes a form that was used to open another form, Dynamics NAV will automatically close that form automatically as well without displaying the above example message. In other cases Dynamics NAV will automatically go to the form that causes it to stop, and then show a message like above, so the user can easily determine whether that form can be closed or if something needs to be done with it before it can be closed.
But sometimes Dynamics NAV will stay on the form the user is trying to close, and display a message like above, and the user does not know what is causing the message. Specifically when that user has many forms open – like for instance when the Navigate function had been used to open different kinds of documents related to an invoice, and next navigated to another document, and so on – it can be tough to identify the exact problem
But no mourning! There is a simple solution: CTRL TAB:
When Dynamics NAV stays on the form that you are trying to close, displaying the message ‘Form X’ cannot be closed because it is locked by ‘Form Y’, simply hit the OK-button on the message and use the keyboard’s CTRL and TAB keys. That will take you to the form that causes the message, allowing you to determine whether that form can be closed or if something needs to be done with it before it can be closed.