Report prints no data

[arage]

Report prints no data
In my report’s on open event I’ve called a macro that will filter the data.
Currently, my report shows nothing.

My macro is a single applyFilter action with a corresponding WHERE clause as such:
[Reports]![rptJoe]![RetailerNumber]=50138

This field appears in the detail section of my report, the report contains no grouping levels at all.
I also switched the filterOn property of the report to YES.
The recordsource of the report is a query made up of 3 tables & a crosstab.
Please advise.

 

[llkhoutx]

Filter your data with a query, not a macro. That's one of the simplest uses of a query. Sometimes, one runs multiple queries in sequence.