Finally!
I was able to get the subform to work, though part of the problem was that my SQL was coded directly into the control source box, instead of being named as a query. Once I named the query, then established a relationship between the query and the table, the subform was no longer...