How to change the RecordSource in a SubRe****t

Dear reader,



The syntax for the VBA code to change the RecordSource of a Master Re****t
is:



            Me.RecordSource = "TableOrQueryName"



But now the syntax to change the RecordSource of a SubRe****t:

I think it has to be something like this:



            Re****ts.MasterRe****tName.SubRe****tName.RecordSource =
"TableOrQueryName"



But this is not working.

Is there a working syntax for this?



Tanks for any help.

Kind regards,

Simon