You hide the Navigation Pane programatically by using the WindowHide RunCommand action in Microsoft Office Access 2007. You then try to display the Navigation Pane by putting the focus on it. You do this by using the NavigateTo action and then calling the WindowUnhide RunCommand action. When you do this, the Navigation Pane is not displayed.
Back to the top
To work around this problem, use the SelectObject action instead of the NavigateTo action before you call the WindowUnhide RunCommand action. To do this, follow these steps:
| 1. | Open your macro in Design view. |
| 2. | In the row before the row that contains the WindowUnhide RunCommand action, change the setting for Action from NavigateTo to SelectObject. |
| 3. | In the Action Arguments section, set the Object Type box to Macro, set the Object Name box to the name of the macro, and then set the In Navigation Pane box to Yes. |
| 4. | Press CTRL+S to save the changes to the macro. |
Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top