• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1312
  • Last Modified:

Mainform = Maximize; Subform = Restore

I have a textbox on a "mainform".

When executing event "Double-Click" I bring up another form that allows for data entry.

Here's what I want to achieve:
1. Double-click on textbox... brings up the subform in RESTORE mode
2. At that same time, I do NOT want the mainform to be in RESTORE MODE.  Instead, I want that mainform to remain in MAXIMIZED mode.

It seems like it either way... I can only both view forms via DoCmd.Maximize or DoCmd.Restore.    Again, that's not want I need... mainform should be = MAXIMIZED; subform should be = RESTORED.

Any idea as to how I can force a different mode for either form?

1 Solution
You can open the second form as a pop-up to get it to open restored on top of a maximized form.

To make your form a pop-up, set the PopUp and Modal properties to true.

To open it restored, put a DoCmd.Restore in the form OnOpen or OnActivate event procedure.

To open a form maximized, put a DoCmd.Maximize in the form OnOpen or OnActivate event procedure.

Hope this helps!
TomBock2004Author Commented:
Fabulous!!! That works awesome!

Thanks so much for the prompt reply.


Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now