Open new copy of form

Posted on 2011-04-22
Last Modified: 2012-05-11
Good afternoon,
Ive written an database application which works fine using the following code to open a form:-
DoCmd.OpenForm "frmFaultLog", acNormal, , "[FaultNo] = " & lisFaults.Value, acFormEdit

Open in new window

However if I then click another calue in my List then the previous opened tab changes its record to the second click (as it should), my question is if possible can I load multiple copies of my for 'frmFaultLog', so I can load multiple jobs up at the same time?

Something like:-
frmNew as new frmFaultLog
frmNew.fliter = "FaultNo=27"

Open in new window

Question by:tonelm54
    LVL 119

    Expert Comment

    by:Rey Obrero
    yes, it is possible
    in the form's module place this

    option compare database
    option explicit
    dim frmNew as Form

    in the click of a btn

    private sub btnNewForm_click()

    set frmNew = New Form_frmFaultLog

    end sub
    LVL 2

    Expert Comment

    I tried it out and not able to do so!!! maybe u gotta have 1 output form at a time!!
    LVL 119

    Expert Comment

    by:Rey Obrero
    and, set the hasModule property of the  form to Yes.
    you can find this in the Other tab of the form's property sheet.
    LVL 119

    Accepted Solution

    see this sample db
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    <so I can load multiple jobs up at the same time?>
    I hope you don't need more that 3 forms open at one time, or the screen could get messy...

    Why not just allow for the selection of multiple values (FaultNos) from the listbox
    ...Then display them all with a click of a button?

    Without the need for opening the exact same form multiple times, and using up screen real estate...

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    729 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

    24 Experts available now in Live!

    Get 1:1 Help Now