[AccessD] Open Multiple Instances of a Form and passing a parameter

Lawrence Mrazek lmrazek at lcm-res.com
Sat Aug 4 21:50:07 CDT 2012


'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_frmMainMenu_ShipmentScheduling
    frm.Visible = True
    frm.Caption = frm.hwnd & ", opened " & Now()
    frm.OpenArgs = "test"

    'Append it to our collection.
    clnClient.Add Item:=frm, Key:=CStr(frm.hwnd)
    Set frm = Nothing

When I try to run this, I get the error: " 2135" ... This property is
read-only and can't be set ... pointing to the line:
frm.OpenArgs = "test"

On Sat, Aug 4, 2012 at 9:41 PM, Charlotte Foust
<charlotte.foust at gmail.com>wrote:

> OpenArgs should work.  What's your code look like?
>
> Charlotte
>
> On Sat, Aug 4, 2012 at 7:35 PM, Lawrence Mrazek <lmrazek at lcm-res.com>
> wrote:
>
> > Hi Folks:
> >
> > I've been testing the code on: http://allenbrowne.com/ser-35.html
> >
> > to open
> > multiple instances of a form in Access 2007. It works well, but I need to
> > be able to pass some parameters on to the form I'm opening.
> >
> > OpenArgs don't seem to work.
> >
> > Any ideas?
> >
> > Thanks in advance.
> >
> > Larry
> > Lmrazek at lcm-res.com
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> >
> >
> > Website: http://www.databaseadvisors.com
> >
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list