Grouping Options

[Desstro]

I have a query that returns values from 2 different tables.
Some of the data is check boxes also from both tables.
Is it possible from the design view of the query, set a grouping value for the check boxes, i.e., when one is checked the others automatically uncheck, and if so could someone please explain how to do so?

[evander]

Options:

(1) Yes you can, but it's going to take a simple VBA code (see attached).
(2) You can use radio buttons or option buttons instead, so that there is only one selected item within a group.

Question:
Do the checkboxes have their own fields? Meaning Checkbox1 is linked to Field1, Checkbox2 to Field2 and so on?

If this is the case, you should remove your checkboxes and fields, and create a single field linked to a combobox that gives you the same list of options.

Hope this helps.