Form does not Maximze on return

[Robin Chapple]

I've been using "Maximze" in the "OnCurrent" or " OnOpen" event on
forms for years and today, a small project that will be used by a
colleague and is part of my major project, has refused to work.

So far I have one form, frmMembers. I am providing a menu for
navigation, frmMainMenu. (Unbound of course)

frmMainMenu is the startup form.

A command button on frmMainMenu opens frmMembers.

A command button on frmMembers closes frmMembers and opens
frmMainMenu.

Each form has

=DoCmd.Maximize...in the On Open event

The Main Menu opens maximised when the application is started.

frmMembers opens maximised.

When I close frmmembers frmMainMenu is not maximised.

What have I missed

Robin Chapple

 

[Ken Snell [MVP]]

I often use the Activate event when wanting a form to maximize in this type
of situation. Not sure why you don't see it working as you describe it, but
Activate should work every time.

 

[Van T. Dinh]

Sounds to me that you have a DoCmd.Restore that got executed during the
process of closing frmMembers. (DoCmd.Restore is used to overcome a bug on
Combo / ListBox that uses a parametrised Query as the RowSource. You didn't
have this problem by any chance?)

Like Ken, I use the Activate Event instead of the Open/Load Event for
DoCmd.Maximize.

HTH
Van T. Dinh
MVP (Access)

 

[Robin Chapple]

Van T

No "restore" anywhere in the procedure.

Robin

 

[Robin Chapple]

Ken,

100% success. Many thanks. I've never needed that before.

Robin