Ive written an database application which works fine using the following code to open a form:-
DoCmd.OpenForm "frmFaultLog", acNormal, , "[FaultNo] = " & lisFaults.Value, acFormEdit
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?
frmNew as new frmFaultLog
frmNew.fliter = "FaultNo=27"