A2007 Report not evaluating Where Condition

[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?

 

[Gina Whipp]

Dale,

I will take a stab at this one... Can you post the code you use to Preview?
Sounds like a simple Save command should do the trick but that might depend
on your code.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Dale Fye]

Gina,

Will post the code tomorrow when I get into work.

Dale

Dale,

I will take a stab at this one... Can you post the code you use to
Preview? Sounds like a simple Save command should do the trick but that
might depend on your code.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Dale,

Okie dokie... Also, let me know if the form is unbound.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina,

Will post the code tomorrow when I get into work.

Dale