Using A2007. I have a report that I have been using successfully in Print Preview format for years. I want to change it to Report View. When I switch to report view, I get a message "Data Type Mismatch in Criteria expression". The report is sourced to a query. The sub report is sourced to a table. I reviewed other posting that also discussed this message, but found nothing that fits.
Strangely, If I remove the sub report, the message doesn't appear when I switch to report view. So somehow, the sub report is the source of the message Is this a sign of corruption or is there some logical explanation?.
Not relevant, but earlier, based on other postings and before I found out that the sub was involved, I removed all criteria from the source query and still had the problem.
Any help much appreciated, driving me crazy.