Navigation Pane

[Timothy Stinson]

I read that you can minimize tha navigation pane by selecting F11, but is
there a way when an object such as a query is opened the navigation pane auto
hides?

 

[Brendan Reynolds]

I read that you can minimize tha navigation pane by selecting F11, but is
there a way when an object such as a query is opened the navigation pane
auto
hides?

I'm not aware of any way to do this if the query is opened using the
out-of-the-box Access UI. You could certainly do it if you created your own
form to collapse the Navigation Pane and then open the query, here's an
example ...

Private Sub cmdTest_Click()

DoCmd.SelectObject acForm, Me.Name, True
DoCmd.Minimize
DoCmd.OpenQuery "qryTest"

End Sub