VBA to show Nav Pane in Custom

frethack

New member
Local time
Today, 12:34
Joined
Mar 27, 2020
Messages
1
Good Morning all (well...its morning here anyway)

I have a toggle button to hide/unhide the Navigation Pane, which is only open to admin users. Currently, when the Nav Pane is unhidden (is that even a word???), it pops up in Object View. I would like it to pop up in Custom View. Is there a command or acType to do this?

Im using this to hide the Nav Pane:
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide

...and this to unhide the Nav Pane:
DoCmd.SelectObject acTable, , True

Im assuming there isnt an "acNavigationCategoryCustom", because I tried this as a Hail Mary. Its not difficult to change to Custom, of course...just annoying.

Any help you can give would be greatly appreciated.
 

Users who are viewing this thread

Back
Top Bottom