grouping tickboxes

Hi there

I have a form (continuous Form) that runs on a query off a table

Now this highlights all the duplicate and a user can tick a box to select those items so that they won't re-appear under the query

Now my question is this> is there any way to group the selection so that when a user selects one tickbox all the grouped items are ticked over multiple rows

& which recordset has to be updated the origional table or the continuous Form?

thx Alex

re: grouping tickboxes

How would these groups be determined?

re: grouping tickboxes

There is a field that would match in the line item reference text :

Reference text eg ZX123123123 # commentsField # TickboxY/N
Reference text eg ZX123123123 # commentsField # TickboxY/N
Reference text eg ZX999999999 # commentsField # TickboxY/N
Reference text eg ZX999999999 # commentsField # TickboxY/N
Reference text eg ZX999999999 # commentsField # TickboxY/N
Reference text eg ZX888888888 # commentsField # TickboxY/N
Reference text eg ZX888888888 # commentsField # TickboxY/N