Selecting multiple checkboxes on subform (1 Viewer)

Hi!

I'd like to know how can I select/deselect the checkboxes for all records on the subform when I select/deselect the checkbox on the main form?
I tried the code

but this only select the first record of all records on the subform.
Any suggestion would be appreciated.

hi Frank

Assuming they are bound, you would need an update query, either an existing query or run SQL on the fly. Your query would need to say update fieldX to value of fieldY on FormZ where join field = FormZ.join field.

Are the check boxes on the subform bound to a field in a table?
What are the names of the tables for the main form and the subform?
what are the relevant field names?
What is the joining field (PK on the main table, FK on the second table?)?

Hi Isskint and thanx for the tip.

I made a query as you suggested, but it's not working as it should because it affects all records in the table and not only those it should.

Isskint said:

Are the check boxes on the subform bound to a field in a table?
What are the names of the tables for the main form and the subform?

Click to expand...

Yes, they are. The checkbox "MySelection" on the main form "fGroups" is bound to the table "tGroups" field "Groups_Selection". The checkbox "MySelection1" on the subform "subfOffers" is bound to the table "tOffers" field "Item_Selection".

Isskint said:

what are the relevant field names?

Click to expand...

I don't quite understand what do you mean by relevant field names.
On the main form, there are fields like group_ID, supplier_name, offer_ID, price, and total_sum and the checkbox "MySelection"which is bound to the table "tGroups" field "Groups_Selection".
On the subform, there are fields like group_ID, supplier_name, offer_ID, item_ID, item_name, price, etc. and the checkbox "MySelection1" which is bound to the table "tOffers" field "Item_Selection"

Isskint said:

What is the joining field (PK on the main table, FK on the second table?)?

Click to expand...

By now it is probably clear that I do not know much about Access, so I don't quite understand this neither, but I guess PK stands for Primary Key and FK for Foreign Key. If that's the case then I'm a bit lost, because I don't have it. If it would be of any help, I linked the main form with a subform using fields group_ID, supplier_name, and offer_ID. As you can see those fields are in both forms and both tables.

I would appreciate any additional advice.

you do it in the subforms recordset.
on the click event of your checkbox on the main form:

private sub mainFormCheckboxName_click()
dim rs as dao.recordset
set rs = me.yoursubformName.Form.RecordsetClone
with rs
if not (.bof and .eof) then .movefirst
while not .eof
.edit
![comboFieldNameOfSubform].Value = me.MainCheckboxName.Value
.update
.movenext
wend
.close
end with
set rs=nothing
end sub

replaced the blue ones with correct subform and control name.

Thanx arnelgp, it works!