I don't get it. No idea what's bound to Query1 or even if it's relevant. I click the phone button, subform changes, location id combo has list values. No idea what to look for (I mean, what is "all" anyway? 3? 7? 21?). Seems very odd to join 2 fields with those names (locationid and helperid in query1) which doesn't help explain how they're related. I see that company 5 has two locations (id's 1 and 2) and those values show up in tblHelper 13 times, so I'd expect to see 13 combo list items, not the 3 that I get.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.