Navigation Pane is "butting in" to a form in Form View.

[LeonS]

Hello! My db has 4 main forms. Title (on opening the db), Contacts, Utilities and EmailsF. When I move from Title to Contacts (by the press of a button) the form opens, but the screen includes the Navigation pane. This only happens with the Contacts form. And if you leave that form and then return, the Navigation pane is there. I have looked at the Event Procedures for the form and can find nothing that even mentions the Navigation pane. The only thing I have found is a way to hide the Navigation pane permanently. Not something I want to do. The Event Procedures for the Contacts form are On Load, On Open, On Activate. The instructions are position, size, set focus and an inherited refresh. I am sure there is an instruction in there somewhere, but I cannot find it. This problem is fairly new. It has not been happening since I started working on the database. Leon

[isladogs]

In case its useful, I'll provide code to show/hide & minimise the navigation pane

Add the following code to a standard module:

Public Function MinimizeNavigationPane()

    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.Minimize
        
End Function

Public Function ShowNavigationPane()

    DoCmd.SelectObject acForm, , True
    
End Function

Public Function HideNavigationPane()

    DoCmd.NavigateTo "acNavigationCategoryObjectType"
    DoCmd.RunCommand acCmdWindowHide
        
End Function

Now add the following to your form to minimise the navigation pane when your form opens

Private Sub Form_Load()

    MinimizeNavigationPane

End Sub

[LeonS]

Isladogs - thanks for that. I will add that code etc later.
But I am really interested as to why I have to say "stop" or "minimise", when it should not happen in the first place!. What happened to make this unwanted thing happen? I can go between forms, no problem. All of a sudden this nuisance affects 1 form. It does not happen on previous versions (every now and again, I make a copy and start with that - but keeping the old copy for comparison. I have an old version of the form which works well. But I have added more functionality to the latest version!! Leon

[isladogs]

There could be many reasons why it only affects that one form e.g. all forms except that one are popups, code used in startup events etc ....
Without looking at your app, all I can do is make informed guesses, which may not be particularly helpful

[DittoBird]

Apologies if you've done this, but have you turned off the navigation pane, Leon? You can always bypass this by holding the shift key when you open the accdb. This is accessed by clicking on File and then Options.

[LeonS]

Isladogs - Thank you! Yes, you were right, you're informed guess was perfect. It opens properly. Thank you ! Leon

[LeonS]

DittoBird - many thanks for your contribution. But the problem was solved before I got to your reply!! Many thanks, Leon

[Micron]

By any chance is there code on this form that resizes something (that thing may turn out to be the nav pane) or creates a link to a nav pane object to do an export?
Are you using DoCmd.SelectObject somewhere in your code when this form opens?

Maybe post form code. I cannot recall ever needing a form Activate event.

EDIT - so the problem was what, exactly?

[LeonS]

Micron - Thanks for that. The problem has been solved!! The form was not marked as Pop Up. And I thought I checked that, obviously not.

[LeonS]

Chaps - just to give you an update on my (lack of) coding skills. You will be pleased to know that I checked all the Controls against the code. I have reported already that I printed off all the code behind the 4 main Forms. There were 50 pages. I have since been through the code and removed all those parts that were not needed or appeared to be duplicates of earlier attempts to get something to work. I am now down to 21 pages!! Although that will increase when I add in all the lines of code that are missing, through lack of knowledge. And the database now Repair and Compacts down to 11 Mb. Down from 112 Mb. And it all works - although there are a couple of (I hope) small things I need to fix. Thank you, Leon