I'm not sure when this problem became a problem. I designed a many queries each using multiple linked tables, all have developed the same problem. One particular query tracks instructor report submission. the tables linked are Instructor, with instructor identifying information, Course schedule with the semester schedule and a course description table that has course information by unique course number, such as course description and identifies which reports are required for each course number. Each report name is a yes/no field. Instructors can teach multiple classes of the same course number and can teach multiple classes of different course numbers. There are multiple class sections (offerings) of most course numbers. Each output record is every class taught which requires a specific report which has not been checked YES. Each record also lists the instructor's email address from the Instructor table.
When I developed this three table query, I was able to open the query in a table configuration, then use it as a check sheet. As the reports came in I would click the yes/no box, changing the box from blank to checked, indicating the report was turned in. Completed reports, on subsequent refreshes of the query, dropped off the query output. This has worked for years.
Of late, after running the query, I am not able to click the check box to indicate the report has been delivered. I only get that error >ding< and the check box does not change. Inputing text data is blocked as well. Only deleting 2 of the 3 tables from the query re-establishes the edit ability, but that destroys the query's filtering capability.
WHAT HAS HAPPENED? How do I turn this feature back on?