Mainform = Maximize; Subform = Restore

Posted on 2004-10-25
Last Modified: 2008-03-04
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?

Question by:TomBock2004
    LVL 12

    Accepted 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!

    Author Comment

    Fabulous!!! That works awesome!

    Thanks so much for the prompt reply.


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now