Edit recordsource in another form

[JohnGo]

I would like to edit the recordsource in my subform with a click on a button.
The button is in the mainform.


But when providing the form name of the subform

forms![mainformname]![subform] there's no recordsource property!

It seems only the recordsource within the form with the button can be changed
(with me.recordsource).


Does anybody know how to achieve a recordsource change in the subform while clicking a button in the mainform?

 

[Liv Manto]

If your button is on the mainform
Subform1 the name of your subform:

Me!Subform1.Form.RecordSource

 

[JohnGo]

Thanks, I'll try the syntax