Stop a form from maximizing

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Quiver
    New Member
    • Jul 2007
    • 9

    Stop a form from maximizing

    How do you stop a form from maximizing on open. When I close a report, I want "frmMAIN" to open at it's normal non-maximized size. But, it keeps opening fully maximized. Here is my code.

    Code:
    Private Sub Report_Close()
    On Error GoTo Err_Report_Close
    
    DoCmd.OpenForm "frmMAIN"
    Exit_Report_Close:
    Exit Sub
    
    Err_Report_Close:
    MsgBox (err.Number & ": " & err.Description)
    Resume Exit_Report_Close
    End Sub
    Thanks in advance for the help.
  • Quiver
    New Member
    • Jul 2007
    • 9

    #2
    Addendum:

    I have the report maximizing onOpen. If I don't do this the form does not maximize. However, I really want the report to maximize onOpen.

    Comment

    • Quiver
      New Member
      • Jul 2007
      • 9

      #3
      Figured it out! I put a DoCmd.Minimize command in the OnClose event of the report before opening frmMAIN.

      Thanks anyway.

      Comment

      Working...