<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have a form with two embedded
subforms.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>On the OnCurrent event of the first subform, I
synchronise the second one using the Filter and OnFilter properties of
it.</FONT></DIV>
<DIV><FONT face=Arial size=2>This works fine, but generates an error the first
time the Form is loaded.</FONT></DIV>
<DIV><FONT face=Arial size=2>This is because I reference the second subform, but
at this time it is not yet loaded.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>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.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>However, I would like to have a more robust way of
controling the loading order.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Do you have a better solution?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Philippe.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>