How do I Open a form Multiple times

[kmcculler]

I have need in my access application to open a form in multiple windows (each displaying a diffrent data set) at once. Of course the purpose here is to compare the relationships of the data and even do some suffling of that data.
My problem is that on the parent form when I click the command button to open a new form with the new dataset (a selected parent record from a continuous form) it just replaces the form already open.
Is there anyway I can have more than one copy of this form open at the same time each displaying diffrent data sets??
Thank you in advance
Kris Kris McCuller
Programmer Portiva Corp.
kmcculler@portiva.com

 

[nickjar2]

i don't know if this would work:

dim frm as form
sub something()
dim i as integer

for i = 1 to 4
Set frm = New yourFormName
frm.setfocus
next i
End Sub

Nick

 

[jhowley58]

Hey Kris - I do this a lot.. I got some functions .. I'll paste them in tomorrow.. too tired tonight.. But they do work..

John..