Believe me, I try to understand all that, and it's not about language (for me) it's about relating all those names to a myriad of objects you have, some of which appear to be the same name. I saw what subform1 query does, so no issue there I think. I don't think we're on the same page with the No Yes thing. Like I said, when subform1 current event fires, the first record is the active one. The 2nd record contains No, the 1st contains yes. Which one do you expect to govern what happens to subform2?
As an aside, it appears main form subform1 control master/child links are 2 fields from the subform query, neither of which I found on the subform. The main form and the subform are supposed to have related fields on them and I don't see that but somehow you seem to have it working, assuming the data is correct. Perhaps that is a non-issue so we don't need to go there I guess.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.