Undo auto maximize

[svbl]

Hello. I have a form that has multiple command buttons that, on click, would direct me to other forms.

In my Main form, I put the auto maximize code in it's Open event:

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

the problem is, when I open the other forms through the command buttons, it also maximizes those forms. Is there anyway I can have it work only for the Main form and NOT any other forms I open?

 

[boblarson]

Well, when ONE item is maximized in Access ALL items are maximized. If you close the other form and open a new one, you can use DoCmd.Restore in the open event of each of the other forms.

I would work at making things consistent, instead of doing something for one and not for the others. So, if you are going to maximize a form, work as if you will maximize them all. I typically don't use maximized forms for just that reason. But, whatever works for you and what you can live with is the way to go.

 

[svbl]

Thanks bob.

For others in the future wondering the same thing, I found a solution to my problem. I tried setting the forms Pop up to yes and it works ok.