I created a DB in MS Access 2003 that generated a report without any problems.
I upgraded to MS Access 2007 and converted the DB just fine. Unfortunately, I now have some minor issues with the report generation.
1. I have a form that has a date feild. That date is used by queries which feed into the sub-reports that ultimately make it to the report. The Queries have a criteria [Forms]![Generate Report]![Date For Report]. Running the report in MS A 2007, It is as if the query does not recognize that [Date For Report] is populated. The query asks for the date in each query. Since there are 8 queries that feed info to 8 sub reports, this is pretty bothersome. What can I do to make the Queries recognize the date feild in the form?
2. A different report generation gives me an error "Prop Res DLL not loaded". Where do I start looking for a solution to this?