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.

 

[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