A2007 Report not evaluating Where Condition

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

Dale Fye

This problem is intermittent, and only seems to raise it's ugly head the
first time this report is run each day.

I have a report form, which allows the user to select which report to print,
and presents them with a variety of controls to fill in (or not) to limit the
span of the report. The user selects the options FY, to/from date, location
that they want to filter the report on, and click a command button to preview
the report.

One of my users noticed yesterday that the first time he selects a report,
and clicks the preview button, the report returns all of the records, not
those defined by the Where condition. I tested this, and found that this
only happens the first time the report form is opened during a given session
in Access. I put a debug.print line above my docmd.OpenReport call, and the
filter criteria is the same in each instance, but the first time these
reports are opened, Access seems to be ignoring the Where condition.

Any ideas?
 
Back
Top