report filter

D

Dave

Hi,
I created a report a long time ago and set a filter for it to open with.
When I now look at the design of that report, I can't tell what the filter
criteria was by looking at the report's property sheet.
Is there another way to tell?
Thanks,
Dave
 
D

Duane Hookom

Did you look at the query design view of the report's record source? The
filter property of the report is usually set by specifying a where clause in
the DoCmd.OpenReport method.
 
D

Dave

Duane,
The query that the report is based on is a 'general' query that gathers data
for many reports, but doesn't filter anything out.

The command button that activates the report has this behind it's on click
event:
DoCmd.OpenReport "rptCustomerReport", acViewPreview

The property sheet shows Yes for Filter On, but the Filter field is blank...

I'm lost.
 
D

Duane Hookom

If you want to filter a report, use
DoCmd.OpenReport "rptCustomerReport", acViewPreview,,"Your Filter
expression here"
 
Top