Thread: Wierd open form behavior

I have a subform on my main data entry form that is opened with a command button. It's the form where I keep track of surgery cases I need to enter into the database. I call it my "Radar". The form is frmNewCases. The name of the command button is objRadar.

I want the subform to open to a specific size and a specific place on the screen. I have an "on click" event procedure with the following code:

 Private Sub objRadar_Click()
On Error GoTo Err_objRadar_Click

    Dim stDocName As String
    
    stDocName = "frmNewCases"
    
    DoCmd.OpenForm stDocName
    DoCmd.MoveSize 2000, 4400, 9000, 5000
    
Exit_objRadar_Click:
       Exit Sub

Err_objRadar_Click:
    MsgBox Err.Description
    Resume Exit_objRadar_Click

The trouble is, when the data entry form is first opened and I click on the command button for the first time, the subform always opens maximized. When I close the subform and click the button again, the subform opens the way I wanted it.

I can't understand why the subform always opens maximized the first time the command button is clicked, but behaves normally after that.

By the way, I don't want the subform to open as a dialog box because I'm constantly working between the subform and my main data entry form, so I don't want to constantly click to close the subform. Otherwise I would use the windowMode "acDialog".

And I just realized I spelled weird wrong.

Check on what MS has to say about setting the size and see if this makes a difference.

http://office.microsoft.com/en-ca/ac...005187660.aspx

Also, look at this thread and see if it helps you.

http://www.access-programmers.co.uk/...d.php?t=118486

Alan