Charlotte Foust
cfoust at infostatsystems.com
Wed Dec 15 12:57:01 CST 2004
You could give your form a public property to hold the equivalent of OpenArgs and then set it in the code after you instantiated the new form instance. Try reading it in the Load event of the form. Or set the form's filter property if you need to. Charlotte Foust -----Original Message----- From: Francisco Tapia [mailto:fhtapia at gmail.com] Sent: Wednesday, December 15, 2004 10:40 AM To: Access Developers discussion and problem solving Subject: [AccessD] Multi-Instance Forms re-visited So I have the following code in a public module.. the purpose is to have more than one instance of the form where end users can start "multiple calls" and then keep starting newer calls. the following code works really well and in fact I can do what I need with it, except passing openargs... I figure I can use a workaround unless someone here knows of a better way? thanks, ---CODE SNIP------------ Option Compare Database Option Explicit 'Author: Allen J Browne, January 2000 'Email: abrowne at odyssey.apana.org.au Public clnClient As New Collection 'Instances of frmClient. Function OpenAClient() 'Purpose: Open an independent instance of form frmClient. Dim frm As Form 'Open a new instance, show it, and set a caption. Set frm = New Form_frmClient frm.Visible = True frm.Caption = frm.Hwnd & ", opened " & Now() 'Append it to our collection. clnClient.Add Item:=frm, Key:=CStr(frm.Hwnd) Set frm = Nothing End Function Function CloseAllClients() 'Purpose: Close all instances in the clnClient collection. 'Note: Leaves the copy opened directly from database window. Dim lngKt As Long Dim lngI As Long lngKt = clnClient.Count For lngI = 1 To lngKt clnClient.Remove 1 Next End Function ---END CODE SNIP----------------- -- -Francisco http://pcthis.blogspot.com | PC news with out the jargon! -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com