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

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


And Thanks Charlotte!

On Sat, Aug 4, 2012 at 9:50 PM, Lawrence Mrazek <lmrazek at lcm-res.com> wrote:

> '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