multiTab form loses size when report is opend and closed

JSDART!!

Registered User.
Local time
Today, 17:05
Joined
Mar 12, 2004
Messages
31
Hi
Ive been searching for answers need assist.
I have a multi tab form with multiple sub forms and control buttons.
One of the buttons calls a report to come into preview mode.

the problem is when I close the report the multitab form loses its max size.
I have tried
docmd.maximize on the on open, on got focus of the form
and I have tried the
docmd.restore as well with no luck.

any suggestiond greatly appreciated.
J
 
Hi

As a workaround, how about using this in the OnClose event of the report?

Code:
Private Sub Report_Close()
    
On Error GoTo Err_ErrorHandler

    DoCmd.SelectObject acForm, "MyFormName"
    DoCmd.Maximize

Err_ErrorHandler:
    Exit Sub

End Sub

Be sure to use your actual form name.

HTH, Andrew :)
 

Users who are viewing this thread

Back
Top Bottom