[AccessD] How to control subforms loading order?

Yep, JIT loading.  The control on the form has a "source object" property.
Simply set this property for the second subform to nothing, then after the
first subform loads, set the property of the second subform.

John W. Colby
www.colbyconsulting.com

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Philippe PONS
  Sent: Thursday, June 05, 2003 11:19 AM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] How to control subforms loading order?


  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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030605/959e3ade/attachment-0001.html>