Hi People,
On a form I have datasheet, on this datasheet there is also a column of checkbox's (data type Yes/No).
There are 4 rows for each 'record', when I click any of the checkbox's it should place a tick in all rows in the 'record' in this column of checkbox's (data type Yes/No).
Also, if I uncheck the box, all rows uncheck.
Column P has the unique identifier that shows what rows belong to what record.They are grouped together, i.e. ordered list.
So each tick I place in a check box, 4 rows should be ticked, based on the value in Column P.
It will always be 4 rows, as the unique value in column P is repeated for each 4 rows.
Thanks,