By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,655 Members | 1,782 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,655 IT Pros & Developers. It's quick & easy.

Problems loading a sub-subform

P: n/a
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
Jan 24 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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...@gmail.comwrote:
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
Jan 28 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.