Problems loading a sub-subform

[maffonso]

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

[Barry Edmund Wright]

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 <[e-mail]:

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