[AccessD] How to control subforms loading order?

Yes, you can change the loading order by changing the order in which each subform is inserted within the form.
If you insert sub1 and then sub2, sub1 will load first.
Remove sub1 and reinsert it, sub2 will load first.
I guess this is something that is not written in any training book!!
Philippe.
  ----- Original Message ----- 
  From: michael.broesdorf at email.de 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, June 05, 2003 5:42 PM
  Subject: Re: [AccessD] How to control subforms loading order?


        I had the same problem some time ago. I believe the loading order 

        changes if you change the layer of the subform (bring to front/send to back). 

        But my memory is not too clear about this, so please don't hit me if it 

        does not work ;-)

        HTH,



        Michael



        accessd at databaseadvisors.com schrieb am 05.06.03 17:33:19:


              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 listAccessD at databaseadvisors.comhttp://databaseadvisors.com/mailman/listinfo/accessdWebsite: http://www.databaseadvisors.com 



       



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030605/7841746a/attachment-0001.html>