[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/1cdf26a6/attachment.html>