Same query: Subform 0, combobox 1, wins by KO

Hello

I have a table I want to modify but after it's filtered by an ID number.

I have created a query that works great and added a listbox that displays
the IDs and when I select the ID it requeries the query.

Because I want the users to be happy, I have created a form (where the
listbox is), and a subfom object that has created a subform where my query is
ran. I then have a nice form with a datasheet display underneath to tick the
checkboxes I need.

BUT, the problem is that the subform displays the first ID correctly - but
not the other ones. I have tried to link the WHERE to a textbox, unbound
anyways, but it doesn't work.
Finally, I've tried a combobox with the exact same query than the subform
and it does work. For all the IDs.

So why would the subform not work where the combobox does??
Any chance I can use a different way to display a table and modify
checkboxes for several entries?

THANKS a lot for all the great help