How to prevent Navigation Pane from collpasing

[MattLewis]

Anytime I open a form in "Modal" mode, it collapses the navigation pane. Is there a way to prevent this inconvenience?

[MattLewis]

It doesn't collapse the pane if I use WindowMode:=acDialog in the DoCmd.OpenForm. But then the whole form opens in a new window. Boo.

[aytee111]

The whole point of Modal is to not allow anything else to happen until the form is closed, so why would you want the nav pane to still show?

[MattLewis]

The whole point of Modal is to not allow anything else to happen until the form is closed, so why would you want the nav pane to still show?

Because I have to turn around and re-open the navigation pane after the modal form closes. It's true that I don't want anything else to happen while the modal form is open, but I also don't want anything else (for example, the navigation pane) to close while it's waiting in the background.

If the navigation pane is open before the modal form is shown, it should (still) be open after the form closes.

[aytee111]

You will have to open it again - in the OnClose event of the modal form add this:

Private Sub Form_Close()

    DoCmd.SelectObject acTable, , True
    
End Sub

[MattLewis]

Thank you. That works.