[AccessD] How to control subforms loading order?

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
>