How to Requery a List in Child in another Child on a form.

[Animelion]

I have lets say Form1 with a subdatsheet on it. This sub datasheet is named Child2 and Links to Form2. On Form 2 I have another sub datasheet named Child3, and this links to Form3. If I am viewing Form1, how can I requery a list named List1 on Form3 ?

Form1
---SubDatasheet Child2 = Form 2

Form 2
---SubDatasheet Child3 = Form 3

Form 3
---List1


---Failed attempts so far---
Form_Form1.child2.child3.List1.requery
Form_Form3.List1.requery

Much thanks for any help I can get. ~Bryan

[maperry]

From the main form (Form1) create a button that has this code:

Me!Child2!child3!List1.Requery

Your problem was using the . operator where you should have been using the bang operator. The Me refers to the form that contains the button.

Be careful about nesting so many sub forms.