Checkable checkbox in a query of group

[Ruegen]

I have areas, and schools that have a date value in their datefield grouped by their area.



I thought adding a checkbox for the area that is grouped would allow me to have it so that I could check the area, and then using a button on a form - null those areas that are checked.

However in the query the checkbox (which is coincidentally grouped in the query) won't check. Is there a way around this as I would like to be able to select multiple areas by checking them and then having a button null the date fields for the schools within that area.

Would I have to use an unbound checkbox?

[Bob Fitz]

I don't think you can change the data in a query that has a GroupBy clause. I think you could use a multiselect listbox on a form to display the areas. Then use code in the OnClick event of a button to change the data of the selected areas.

[Ruegen]

I don't think you can change the data in a query that has a GroupBy clause. I think you could use a multiselect listbox on a form to display the areas. Then use code in the OnClick event of a button to change the data of the selected areas.

I'd love to be able to only update the date fields those schools that are queried... is there another way? It's not the areas I need to change/update but the table linked.

[June7]

An unbound checkbox wouldn't work because unbound control reflects the same value for all displayed records.

Could possibly use a listbox that allows multi-selection then code would cycle through the listbox items and run an UPDATE sql for the selected items.

[Ruegen]

An unbound checkbox wouldn't work because unbound control reflects the same value for all displayed records.

Could possibly use a listbox that allows multi-selection then code would cycle through the listbox items and run an UPDATE sql for the selected items.

ok I will give that a go. I am guessing update sql in vba?

[June7]

Yes, execute SQL in VBA.