Open new copy of form

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

Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
see this sample db
Rey Obrero (Capricorn1)Commented:
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
I tried it out and not able to do so!!! maybe u gotta have 1 output form at a time!!
Rey Obrero (Capricorn1)Commented:
and, set the hasModule property of the  form to Yes.
you can find this in the Other tab of the form's property sheet.
Jeffrey CoachmanMIS LiasonCommented:
<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...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.