Maximizing Forms

[Nick]

I have two questions if someone can help me with.
First; I would like to add to the expression below, so
that the primary from, Orders, Maximizes when it becomes
active:

Private Sub Form_Activate()
Me![Orders-sub1].Requery
End Sub

Second; Is there any way that I can have a form stay
maximized while another form is opened and then closed.
That is if I am working with a form that is maximized and
I press a button to open another form that is not full
screen without the previous form restoring when the second
form is opened and then maximizing when you close the
second form.

Thanks for your assistance.

Nick

 

[Arvin Meyer]

I have two questions if someone can help me with.
First; I would like to add to the expression below, so
that the primary from, Orders, Maximizes when it becomes
active:

Private Sub Form_Activate()
Me![Orders-sub1].Requery
DoCmd.Maximize
End Sub

Second; Is there any way that I can have a form stay
maximized while another form is opened and then closed.
That is if I am working with a form that is maximized and
I press a button to open another form that is not full
screen without the previous form restoring when the second
form is opened and then maximizing when you close the
second form.

Thanks for your assistance.

In the form that you wish to maintain it's size, remove the
Maximize/Minimize buttons using the property sheet. Then change the poup
property to Yes. The form can be opened normally, after the first form is
opened maximized.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access