OK. I have two databases that I'm currently having problems with. I am a youth pastor, and I have an annual database to keep track of our children's information that I redo every year (Programs 2014, Programs 2015, Programs 2016). To make things easier each year, I have a template that I can just Save as that year. This year I figured out how to automatically assign our children to certain programs based on their school grade and gender. In the table (General Info), I have created calculated cells that automatically check the checkbox if children fit certain criteria. I have also started using forms this year (don't know if that makes a difference). I have a report (Troop Information) that I use to register the children and have it grouped by troop.
This year when I went to look at the report, it just told me "Type mismatch" and wouldn't open. I can only open it in Design View. I tried creating the report again with the wizard and received this message: "The Wizard is unable to preview your report, possibly because another user has a source table open in exclusive mode. Your report will be opened in design view." In my quest to find the source of this problem and attempt to correct it I decided to open up the template to see if I was having the same problem. I cut and paste 6 of the records from this year into the template and ran the report. Only 3 of the records showed up in the report, and it had the children checked off for troops they weren't in or eligible for.
This report is only tied to a table. It is NOT tied to a query. I have not applied any filters. Everything on properties between "Programs 2016" and "Programs template" is the same.