Transfering RecordSource/OrderBy of form to Report 1

[fdcusa]

I have a subform within a form that displays filtered data based on dynamic selection criteria which is assigned to the RecordSource/OrderBy of the subform. On this form, I have a "Print Results" button -- OnClick, I would like the RecordSource/OrderBy of the subform to be copied to the Report, then run the report. What I have that doesn't work is:

Reports!rpt_frmTaskMain.RecordSource = Forms!frmTaskMain.frmTaskSub1.RecordSource
Reports!rpt_frmTaskMain.OrderBy = Forms!frmTaskMain.frm.TaskSub1.OrderBy

On execution I get error: "Object doesn't support this property or method"

I am thinking this can be done, and likely have the references wrong. Help?

 

[Remou]

There is a 'form' missing from your statement. You may wish to look at:

http://www.mvps.org/access/forms/frm0031.htm

 

[fdcusa]

Thank you, Remou, for not giving me the full answer!

In your suggested reference I found the key, and then common sense kicked in telling me the report has to be open to receive the data, so I moved the lines to the OnOpen event of the report. Works like a charm now. Thanks!

Reports!rpt_frmTaskMain.RecordSource = Forms!frmTaskMain!frmTaskSub1.Form.RecordSource
Reports!rpt_frmTaskMain.OrderBy = Forms!frmTaskMain!frmTaskSub1.Form.OrderBy