keep a form maximized

Posted on 2009-02-11
Last Modified: 2012-06-21
I have two forms opened at the same time
The one at the back is opened as normal maximized form
The one at the front is opened as a dialog
There is a button in the second form(the dialog one) , this button is to open a report, and at the same time it is make the (the dialog form) invisible.
When I close the report, I make the (dialog form) visible again.
but the first form (which is at the back) appear as restored (I mean not maximized).
I did not understand why access act like that.
What can I do to make it remain maximized?

Question by:M_SOLAIMAN
    LVL 84
    Try this in the Activate event of that form:




    Accepted Solution

    The concentrate now is at the dialog form which is on the front
    And the form at the back is restored now(not maximized).
    I need a code to maximize the form at the back. But this code I need to write it in the other form(dialog form).
    How can I point to (form1) from (form2) to do this maximization of (form1).
    I am not sure if I describe my problem well?

    LVL 84
    Sorry I missed your comment:

    you can refer to other forms like this:


    In order to maximize this other form from your dialog form, try this:

    Add a code procedure to the Second form (the one you want to maximize):

    Function MaximizeMe()
      DoCmd.SetFocus "nameOfSomeControlOnThisForm"
    End Function

    Now, from the dialog form, do this:



    Author Comment

    Thank u 4 reply
    I'll try it and refer back 2 u


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Familiarize people with the process of utilizing SQL Server functions 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 Ac…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    732 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

    20 Experts available now in Live!

    Get 1:1 Help Now