Recent content by EGJ

Nevermind... problem solved. I had a filter being set behind the scenes from DoCmd.OpenReport. The lesson is... when you set a filter in DoCmd.OpenReport, no amount of code in Report_Open can bypass it. It seems to be set on top of Form.Filter.

I am working on a dynamic crosstab report in Access 2003. I've sorted out most of the typical issues re. setting field names and building the 'IN' clause of the SQL dynamically in the Report_Open routine - thanks to many helpful examples on these forums and elsewhere. My question is about...