Hi people,
My main form has a subform nested with another subform, both subs
work as a subDatasheet. Indeed I keep the mainForm just to put some
filters. Whenever I open de MainForm I have no problems. The mainForm
opens and show the subform in shape of subDatasheet. The problem is
that the sub-subForm doenst load unless I click on the subform. If the
subform doesnt load its
impossible to refer to it via code. Everytime I try to refer to a
property I receive an error (unless I click on the subForm to activate
it). Someone told me to alter the SourceObject on the code, but I did
it and the problem goes on.
Please help me. Thankyou all
Maffonso

Hi,

I believe you need to put a requery of your sub-subform in the
Form_Current event of your subForm

Private Sub Form_Current()

'I believe one of the following will work - just experiment a little.
Me![sub-subform].Requery
' or
Me![sub-subform].form.Requery


end sub


On Jan 24, 11:43 am, maffonso <mmaffo... [at] gmail.com> wrote:
> Hi people,
> My main form has a subform nested with another subform, both subs
> work as a subDatasheet. Indeed I keep the mainForm just to put some
> filters. Whenever I open de MainForm I have no problems. The mainForm
> opens and show the subform in shape of subDatasheet. The problem is
> that the sub-subForm doenst load unless I click on the subform. If the
> subform doesnt load its
> impossible to refer to it via code. Everytime I try to refer to a
> property I receive an error (unless I click on the subForm to activate
> it). Someone told me to alter the SourceObject on the code, but I did
> it and the problem goes on.
> Please help me. Thankyou all
> Maffonso