report filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
If you want to filter a report, use
DoCmd.OpenReport "rptCustomerReport", acViewPreview,,"Your Filter
expression here"
 
Back
Top