I came across this thread while searching for a solution to a similar problem. (My database is also built on SharePoint lists.) I've figured out a simple solution that works for me: Reassign the recordsource for the subform before running the problematic query:
Me.[Subform Control...