Why will my form only open up maximized?

[RSW]

The first form of my database opens up maximized, the way I want it. However, clicking to open a different form always brings up that second form maximized.

For the second form:

Width 3.7917"
Auto Center No
Auto Resize No
Fit to Screen No
Border Style Sizable
and in Design View, the form looks small.

Whether opening this form directly, or opening it from the main form, it always pops up full screen in Form View.

Does anyone know what I am missing? I have followed any instructions I can find on how to resize a form, and nothing has worked.

Thanks in advance!

 

[boblarson]

If one object (report, form, query, table, or database window) is maximized, so is everything else. If you want to have one maximized and the others not, you have to set the POPUP property of the form or report to YES. Other objects do not have that property.

 

[Mr. B]

Once the Maximize property is set for one form or report, that property remains set and affects every form or report from that point forward unless you issue another command to restore the property to not be mazimized.

Use VBA code in the on open even of your second form as:

docmd.restore

 

[RSW]

Thank you both so much for the super quick response!