CODEWITHSUNDEEP
ms-accessvbams-access-2010
Mike
Mike

Reputation: 145

Form Open is hiding and disabling the Navigation Pane

I am debugging an access application built by another developer. As I debug, I want to be able to see the results of specific queries and tables as I go. On one particular form, the navigation pane (which includes the list of tables, queries, forms...etc) is minimized and disabled any time the form is open. The navigation then maximizes and is fully restored when the form is closed or in design mode.

I've searched throughout the VBA and there doesn't seem to be anything that's controlling this behavior. I know there is some VBA that can do this like 

DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide

but none of these can be found in the code behind. Any idea what else might be causing this?

Upvotes: 1

Views: 4881

Answers (1)

PhilS
PhilS

Reputation: 1661

The Modal property of the Form will cause such behavior when set to true.

You can set that property on the property sheet for that form in the "Other" tab. It can be set by VBA-Code with code like this:

Forms("yourForm").Modal = True '(or False to disable)

Upvotes: 1

Related Questions