Filter pivotchart in report

[swas]

Hello,

I have a pivotchart to display some data, and works fine including filtering
on open using

DoCmd.OpenForm strFormName, acFormPivotChart,,filterdata etc...

I want to insert this pivotchart in a report, and all works fine except for
referencing the subform filter property,

me.subSubFormName.form.filter = "XYZ"

I get an error "---------------------------
Report_Open_Error
---------------------------
2455 You entered an expression that has an invalid reference to the property
Form/Report.
---------------------------
OK
---------------------------

I don't know how to reference the filter property in the subform, and to be
the above code should work. I am assuming my problem lies in placing a form
in a report, or perhaps perculiar to pivotchart view?

Any help?


Thanks


swas

 

[swas]

To expand on my problem here, I was trying to set subform properties in the
report_open event, which is too early.

My problem manifests though - on my laptop I use Access 2007 and reports
have load events among many others, and I can get my code working there
(Using a 2003 mdb). On my work pc with Access 2003 I only have report_open,
and some limited others (Activate, focus etc...). Report_load doesn't exist,
and hence doesn't fire.

Should I have report_load events for A2003 or are these only new for 2007?
Or could I have a corrupted installation?

Becoming frustrating...

thanks

swas