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

I have checked deeper and realized that it does only work with the first ID
of the table: that is if the table's first entry's ID is a 6, then it will
only display the 6s correctly.

Another surprise is that now the subform does work well as a query, but it
does not work once in the other form's object.

I can't understand this one... just weird...

"The Dude" wrote:

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

I have checked deeper and realized that it does only work with the first ID
of the table: that is if the table's first entry's ID is a 6, then it will
only display the 6s correctly.

Another surprise is that now the subform does work well as a query, but it
does not work once in the other form's object.

I can't understand this one... just weird...

"The Dude" wrote:

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