I am using this code to open the form:
Code:
Private Sub Form_Load()
DoCmd.ShowAllRecords
DoCmd.GoToRecord , "FrmInputData", acNewRec
DoCmd.RunCommand acCmdAppMinimize
End Sub
It minimizes the application and set the form for a new record. This code is fine.
Now I have a command button to open a report:
Code:
Private Sub OpenrptRollup_Click()
DoCmd.Close , ""
DoCmd.OpenReport "rptRollup", acViewReport, "", "", acNormal
End Sub
This in essence works fine it closes the form and opens the report. But it opens the report minimized.
I have tried Report_Activate, Report_Load, Report_Current to get it to automatically resize itself for viewing. the report is set for pop up, center and resize. So far a no go.
Code:
Private Sub Report_Load()
DoCmd.MoveSize , , 20000, 20000
End Sub
I think it has something to do with the "DoCmd.RunCommand acCmdAppMinimize" as the report will open fine when I have Access Maximized.
Suggestions?
Thanks
T