Apologies to all that contributed here and thanks to you all!
I got a working version using the Allen Browne approach (thank you Allen).
I have one small problem. I now want to pass a parameter to the form that I'm opening so I added an extra line to what I had and have now got
Set frm = New Form_ListSales
frm.Visible = True
frm.Caption = frmName & " " & frm.Hwnd & ", opened " & Now()
frm.OpenArgs = StrOpenArgs
I thought this was work but I'm getting an error stating that frm.openargs is readonly. So how do I pass a parameter over to the each new form in the collection?
I got a working version using the Allen Browne approach (thank you Allen).
I have one small problem. I now want to pass a parameter to the form that I'm opening so I added an extra line to what I had and have now got
Set frm = New Form_ListSales
frm.Visible = True
frm.Caption = frmName & " " & frm.Hwnd & ", opened " & Now()
frm.OpenArgs = StrOpenArgs
I thought this was work but I'm getting an error stating that frm.openargs is readonly. So how do I pass a parameter over to the each new form in the collection?
Last edited: