How to stop DoCmd.Maximize in one form from maximizing all later forms

[Andy Sauer]

Hello,

For one form, I want it to maximize upon opening. So, in that form's "On Load" Event, I put in:

Private Sub Form_Load()
DoCmd.Maximize
End Sub

However, all subsequent forms that I open will maximize. I do not want that. I want the one form mentioned above to open maximized, and I'd like the other forms to open at their saved sizes.

For the subsequent forms, I tried putting in code in their "On Load" events, using DoCmd.MoveSize. However, even with height and width specifications, it will still open maximized IF I have opened that other form first.

In short, how can I have one form open maximized and other forms not? Thank you very much!

[Andy Sauer]

Ah, once I again I asked too soon when the answer was in another post.

For the one form, I will use Maximize:

Private Sub Form_Load() 
DoCmd.Maximize 
End Sub

For subsequent forms, I will use Restore:

Private Sub Form_Load() 
DoCmd.Restore
End Sub

In addition, I can add Restore to the "On Close" for the form that maximizes:

Private Sub Form_Close()
DoCmd.Restore
End Sub

This will prevent it from maximizing a form that was already open.

The combo of the above seems to work, unless anybody has a better solution. Thank you.

[NeoPa]

I guess, though you explain it in a strange way, you now realise that you cannot stop all forms being maximised and restored whenever any one of them is maximised and restored. Your solution gets around it in a workable way though. The only thing it doesn't give you is the option to have one form maximised with others in the foreground that are restored.