Modal Form Issue

[JamesJoey]

From a main form I open a form that is Popup=No and Modal=Yes.

But, after I close the Modal form the navigation pane remains minimized.

Any ideas??
James

 

[static]

What's do you mean by 'navigation pane'?

 

[JamesJoey]

That thing on the left side of the screen that displays the db objects ie: forms, macros, tables queries and modules.

What should I have called it??

 

[JamesJoey]

Of course it would have been clearer if I had mentioned I was using Access 2010.

 

[Pat Hartman]

If this is a database you are building for others to use, the navigation pane should NEVER be shown. Users should interact only with forms and reports. If this is for your own use just use F11 to reopen the nav pane. There are some strange behavior issues with the nav pane and this may be one of them. There is a VBA command that makes the nav pane visible but it's late and I'm having a senior moment. I'll look for it tomorrow if no one else has posted it. But take my advice to always hide the nav pane instead if the app is not for you personally.

 

[JamesJoey]

I have senior moments when early or late or what ever.

This seems to only occurs when the form is called from another form.
It doesn't seem to happen whit a similar situation in another db.
Probably another corruption.
Another work around. This is getting old with Access.

 

[Minty]

What code are you using to call open the form?

I work (develop) with 3 or 4 databases at work constantly (Access 2010), I only get corruption issues about twice a year, and normally they are related to an Active X component that I really must get rid of when time allows.

Is the database being used by others when you are working in it?

 

[JamesJoey]

DoCmd.OpenForm "Formname"

 

[Minty]

You could try setting the form to open as a dialog instead of using the modal property;

DoCmd.OpenForm "FormName", acNormal, , , , acDialog

It depends what the form is used for. Much more information here https://access-programmers.co.uk/forums/showthread.php?t=179101
and here http://www.kallal.ca/Dialog/Index.html