macro for restoring form

[Linda Helm]

I have my database set up so that when it opens it goes to
full screen, so when I click on a button to pop up another
form I want it to be restore size, not maximized like the
main form so I used a macro to restore the popup form,
only problem is the main form behind it also restores!!!
HELP!!

~Linda

 

[Dirk Goldgar]

I have my database set up so that when it opens it goes to
full screen, so when I click on a button to pop up another
form I want it to be restore size, not maximized like the
main form so I used a macro to restore the popup form,
only problem is the main form behind it also restores!!!
HELP!!

The application has only one Maximized or Restored state, so when you
maximize or restore one form, all non-popup forms are maximized or
restored. However, forms with their PopUp properties set to Yes should
be independent of this. My guess is that your "popup form" doesn't
actually have its PopUp property set to Yes. Try that -- it's on the
Other tab of the form's property sheet in design view.

 

[Reggie]

Linda, One other thing you could try besides what Dirk provided is you could
set the OnClose event of your popup form to maximize your main form


Private Sub Form_Close()
Forms!YourMainForm.SetFocus
DoCmd.Maximize
End Sub