I had the same problem with a subform. I compared properties with a similar subform but could not see any obvious differences.
Eventually decided to create a new subform starting with a blank one, I copied the record source from the faulty subform (SQL in this case) and then added all the...