Dialog form cause other open forms to resize

TechGuise
TechGuise used Ask the Experts™
on
I've had this trouble for a while.    I've tried various combinations of POPUP, MODAL, BORDER SIZE with no luck in fixing the problem.

From a FORM that servers as a menu, a command button is clicked and a report opens in PREVIEW.    
When the report is closed, a small POPUP form opens asking if the report printed OK, and if YES it runs a query that marks things PAID, then closes the popup form.

The problem is that when this dialog form is closed..... the original menu goes from MAXIMIZED to resized (about 2/3 of the screen)
 
I have the OnCurrent, OnGotFocus, etc... set to maximize the form but the user has to click on the form to get it to take that action.

Am I missing something simple, or should I just build in a routine that selects the menu form and maximizes it when the report is closed?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
mbizupNerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
Do you have the following line of code anywhere in your Dialog form:

DoCmd.Restore

?

If so, try removing it.

Also make sure you have the auto resize property set to 'No' in your forms.

Author

Commented:
Thanks for reply....
no "restore" commands anywhere,
already have AUTO RESIZE to no on both forms
Commented:
Along with mbizup's advice,  the pop-up form should work these properies:

Pop-up:  Yes
Border Style:  Dialog


Or use a message box instead of a pop-up form to ask if the report printed.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
or just post a sample of this database that exhibits this issue...

Author

Commented:
Never solved, but I appreciate the effort (as always)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial