[AccessD] How to control subforms loading order?

Christopher Hawkins clh at christopherhawkins.com
Thu Jun 5 13:45:01 CDT 2003


Hm.  I'll have to experiment with that method, then.

Glad you've got it working.

-Christopher-

---- Original Message ----
From: Philippe.Pons19 at wanadoo.fr
To: accessd at databaseadvisors.com, 
Subject: Re: [AccessD] How to control subforms loading order?
Date: Thu, 5 Jun 2003 20:15:24 +0200

>Yes, it's ok now, than you.
>
>In some situation, I have had difficulties to use Child/Parent 
>properties.
>Using Filter works always, gives a better control, and is sometimes 
>faster
>when you switch from one record to the other.
>
>Philippe
>
>----- Original Message -----
>From: "Christopher Hawkins" <clh at christopherhawkins.com>
>To: <accessd at databaseadvisors.com>
>Sent: Thursday, June 05, 2003 5:38 PM
>Subject: RE: [AccessD] How to control subforms loading order?
>
>
>> Sure.  Given main form frmMain, first subform sfrmFirst, and second
>> subform sfrmSecond:
>>
>>
>> 1) Place an empty subform control on frmMain and sfrmFirst.  When I
>> say empty I mean, the SourceObject property of the control should 
>be
>> blank.
>>
>> 2) frmMain_OnLoad should set the .SourceObject property of it's 
>blank
>> subform control to 'sfrmFirst'.
>>
>> 3) sfrmFirst_OnLoad should set the .SourceObject property of it's
>> blank subform control to 'sfrmSecond'.
>>
>> 4) Filter as needed.
>>
>> Curious; why are you synchronizing the two subforms via the Filter
>> property instead of the Child/Parent properties provided for that
>> purpose?
>>
>> -C-
>>
>> ---- Original Message ----
>> From: Philippe.Pons19 at wanadoo.fr
>> To: AccessD at databaseadvisors.com,
>> Subject: RE: [AccessD] How to control subforms loading order?
>> Date: Thu, 5 Jun 2003 17:19:29 +0200
>>
>> >Hi,
>> >
>> >I have a form with two embedded subforms.
>> >
>> >On the OnCurrent event of the first subform, I synchronise the
>> >second one using the Filter and OnFilter properties of it.
>> >This works fine, but generates an error the first time the Form is
>> >loaded.
>> >This is because I reference the second subform, but at this time 
>it
>> >is not yet loaded.
>> >
>> >I found a workaround by removing the first subform from the main
>> >form and reinserting it, as it seems Access loads the subforms in
>> >the same order at which they have been inserted.
>> >
>> >However, I would like to have a more robust way of controling the
>> >loading order.
>> >
>> >Do you have a better solution?
>> >
>> >Thanks in advance,
>> >
>> >Philippe.
>> >
>>
>> _______________________________________________
>> 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