changing record source on subform

[poet1234]

Hello, I have a form with a subform. I want to change the record source on the subform during an OnClick event. I am not sure what I'm doing wrong, but I get a "object does not support this method" error. Can anyone help? Thanks in advance.

 

[Meltdown]

Just a syntax problem, try addressing the subform like..
Me!SubFormName.Form.Recordsource = "Your SQL String"