How to set source of subform

[access83]

Hi All,

I've always had problems with subforms and todays no different. I'm trying to set the source of my subform to the results of a stored procedure. The result of the stored procedure is stored in a recordset. However, no matter what I try nothing works. I either get the error..
"Object doesn't support this property or method"
or
"The expression you entered refers to an object that is either closed or doesn't exist"

I've tried

Forms![MainForm]![mySubForm].Form.Recordset = myRecordset

Forms![MainForm]![mySubForm].Form.RowSource = myRecordset

Any help is much appreciated

 

[RainLover]

A Query would be much simpler.

But if you want to go that way you need to post the complete Code.