Form wrangle

[Sandy]

I have a form "Navigation" with a button "Administration". The "Navigation"
form opens maximized however when I click on the "Administration" button the
"Navigation" form restores when the "Password" form pops up. I would like
the "Navigation" form to remain maximised when the "Password" form pops up.

Code as follows

Private Sub Administration_Click()

DoCmd.OpenForm "Password"

'if this line not included the "Password" form opens maximised!!
DoCmd.Restore

End sub

Thanks
Sandy

 

[Dirk Goldgar]

I have a form "Navigation" with a button "Administration". The "Navigation"
form opens maximized however when I click on the "Administration" button
the "Navigation" form restores when the "Password" form pops up. I would
like the "Navigation" form to remain maximised when the "Password" form
pops up.

Code as follows

Private Sub Administration_Click()

DoCmd.OpenForm "Password"

'if this line not included the "Password" form opens maximised!!
DoCmd.Restore

End sub

If you set the Password form as a popup form, it won't be maximized even if
other forms are currently maximized. You can set the PopUp property on the
Other tab of the form's property sheet in design view.

 

[Sandy]

I have spent ages trying to manipulate this and it's that easy.
Thank you very much Dirk
Sandy