changing a subforms RecordSource - Error 2455

[RemyS]

I've got a main form with 6 subforms, all based on a combobox value in the main form.

They all work properly at first.

The Tables I am using get pretty big, so I decided to use an archive table to remove older data and thus speed up the querying time.

However, when I want to look at the older data I need to change the forms recordsouce

Me.DEALS_subform.Form.RecordSource = "SELECT * FROM ... etc;"

at one stage this worked.

But now I get Run-time error '2455'
"You entered an expresion that has an invalid reference to the property Form/Report"

If I mess around in the code, sometimes I can get it to work.
This is really confusing me.

Can anyone help?


Thanks,
Remy Still new to DB's and enjoying learning day by day