Controlling Navigation Pane from a form

[KarenW]

Hi
In my Access 2007 application I provide a number of buttons for users
to control what they see on the screen. My users go back and forth between
the initial 'switchboard' type of form (as a frontend interface) and the
actual tables and queries that are listed in the navigation pane. I have a
button that shows/hides the nav. pane (with a simple SendKeys "{F11}"
snippet) -- but I would like the groups to be collapsed when the pane
becomes visible. Right now, when the button is clicked, the nav. pane is
displayed, but will have various groups expanded depending on what the user
had done before hiding the pane.
Is there a command to do this -- I can't seem to find one?
Also, is there a way to make the pane completely disappear--when you use
SendKeys "{F11}" it only shrinks down to the vertical strip on the left side?
thanks much, KarenW

 

[Jeanette Cunningham]

Private Sub cmdShowNavigationPane_Click()
DoCmd.SelectObject acTable, , True
End Sub

Private Sub cmdHideNavigationPane_Click()
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
End Sub


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia