Requery Subform within a subform from another subform

[memaxt]

Hi All,

As the title says, i'm trying to requery a subform after update from a another subform which are both within a main subform that is on a main form.

I have attached a image which makes it alot easier to explain on what i'm trying to achieve. (Please see image)

goal is to requery subform3 from subform2

I have tried the following code in Subform2 in after update event:

Forms![Main Form].[Subform1].form.[Subform3].form.requery

or
Forms![Main Form].[Subform1].form.[Subform3].requery

I have tried different combinations but i'm still not winning.

any help would be truley appreciated.

Many thanks
Max

 

[memaxt]

any ideas? sorry to pester, I can porgress futher until this issue has been resolved

 

[spikepl]

Follow the method I gave here: http://www.access-programmers.co.uk/forums/showthread.php?t=269291

 

[JHB]

Try the below:

Me.Parent![NameOfSubform3].Form.Requery