Referencing a subform of a subform of a subform of a subform to requery the last subform

[killernet]

I'm trying to refer, using vba, from my one form to a subform many levels below:

My current structure is:

Navigation Control Form > NavigationSubform > Custom Form1 > Navigation Control Form > NavigationSubform > Custom Form2

From a button on 'Custom Form 1' I'm trying to reference 'Custom Form 2' to perform a requery (ie. ___ [CustomForm2].Requery) on 'Custom Form2'.

I have tried for days to resolve this and this is my last resort does anyone have any suggestions for the syntax.

Thanks in Advance

Law

 

[PHV]

Me![name of Navigation Control Form Control].Form![name of NavigationSubform Control].Form![Name of Custom Form2 Control].Form.Requery

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[killernet]

Thanks, but I get 'Microsoft Access can't find the field 'CustomForm2' referred to in your expression. Seems to think it's looking for a field not a form?

Do you have any other suggestions?

Thanks
Law

 

[PHV]

Don't use the form's name but the name of the control hosting it.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886