Date Filtered Reports worked in 2003, crashes in 2007

[Emblem1]

Some reports that worked in 2003 crash Access entirely in 2007. I have a form that text boxes on it for starting date and ending date, and code behind the form to build a strWhere condition to filter a report. The report is based on a query, and the filter is applied to the report via the code on the form. I don't think the problem is with the code, because if I just run the report manually without using the form, the report still crashes MSAccess compleletly. Doing a bit of reading, it seems that there were some changes to reports and filters in access '07.
When the filter is passed on to the reports, it looks something like this:

([qryLocationPMHistorylastdateTrunklineOnly]![Last_PM_Date] <= #09/24/2007#)

How do I fix my reports so they work again?

 

[Emblem1]

Also, even if I manually remove the filter before running the report it still crashes. The record source for the report is a query, and the query works fine when I run it.

 

[sxschech]

I also had a problem with a report. Ran fine in 2003, converted to 2007 and it actually was running fine for several weeks. All of a sudden, it crashed. Since I created a backup of the file every week, I thought, ok, I'll import from that last week backup file when the report still ran. This did not work. The report still crashed. I even imported a copy of the report from several months ago, when it was still running under 2003, and still crashed. What saved me was that I had a similar report (same layout and format, only titles of text box and record source query name were different) in the same file that continued to run fine. I copied that, and changed the record source and the text boxes to recreate the display information of the problem report and at least so far, the report is running fine.