Solved Unhide Navigation Pane on AutoExec

[Pat Hartman]

You don't get to muck around with the innards of this web page software. Your users should not get to muck around with an application you build for them. So YOU can press F11 to open the Nav Pane. Once you allow users to modify objects, you can no longer simply replace their FE with your new and improved version. You get snarled with trying to not lose their modifications.

 

[vhung]

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide

If this code aim to open the hidden pane or hide, then have to single it out;

if using "DoCmd.SelectObject acTable, , True" is to open navigation pane
then using "DoCmd.RunCommand acCmdWindowHide" is to hide the navigation pane

So why have to use the codes together in one command, probably it will hide the navpane base on the last command of the series
otherwise if reverse it then hidden the current form and unhide navpane

rather use codes below to stay current form open

DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
DoCmd.SelectObject acTable, , True


And now thanks to this thread,
i just reviewed and reconstructed my codes for the navpane command,.