Navigation Pane Opening/Closing

[benkingery]

I have a user login form wherein my users authenticate their employeeid as well as their person PIN. If the user authenticates with a valid username/password combination, then the employee id and the role (permissions) for that user are stored on the form and it is minimized to stay open. If the user that authenticates has "Admin" role then I want to unhide the navigation pane. For all other roles I want the navigation pane to remain hidden.

That said, the default setting in the database is for the navigation pane to remain hidden. I have a piece of code on the login form as follows:

If Me.role = "Admin" Then
    DoCmd.SelectObject acTable, "NavigationPaneObject", True
    DoCmd.RunCommand acCmdWindowUnhide
Else
    Exit Sub
End If

This is successfully unhiding the navigation pane, but I'm getting the following error message and I don't know how to get it to go away.

"Run-time error '2544':

"Microsoft Access cannot find the NavigationPaneObject you referenced in the Object Name argument."

The code is unhiding the navigation pane as I expect, but this message is wierd...can't figure out why it comes up and how to get it to go away.

Any thoughts out there?

 

[TJPoorman]

Try just DoCmd.SelectObject acTable, , True