Restore only active window

[reginaldmerritt]

I have several forms which are all maximized by

DoCmd.Maximize

I have another form which I want to open as a sort of pop up window. So I've set its Form_Load event procedure to

DoCmd.Restore

However, this restores the maxmized form behind it as well.

Is there any way of just restoring the active form?
Or is there a way of setting a forms size?
(DoCmd.Movesize doesn't seem to work when DoCmd.Maximize has been used)

Thanks.

[reginaldmerritt]

Solved. Well sort off.

One of the properties on a form is PopUp, when set to true this will restore the form and keep the other maximized.

However, apparently you can't delete records on a PopUp form

http://bytes.com/topic/access/answers/893836-how-maximize-one-form-not-others

[missinglinq]

However, apparently you can't delete records on a PopUp form...

Setting a form to Popup or Popup/Modal does not, in and of itself, prevent records from being deleted! The poster in the linked post has to have something else going on other than the form being set to Popup to cause the problem.

Linq ;0)>

[reginaldmerritt]

Thanks for the info. :)

[NeoPa]

See the linked thread for the code Reginald, but fundamentally you'd need to have all restored, but resized to appear maximised (where in other circumstances you'd just maximise them).