Form to sub form problem

[normie]

I have a form with a combo box the pulls up and filters a query in a subform...there can be 1 to 100 lines in the subform
What I want to know is how can I connect the two forms to be able to check a box on the form and have it fill in the check boxes in the subform without having to click all in the subform?


This will save time and errors

[June7]

You want to automatically update a yes/no field in up to 100 subform records? This will require VBA code. The code can either execute an SQL UPDATE action or open a recordset of the subform records and edit the recordset in a loop structure.

The SQL action would be like:
CurrentDb.Execute "UPDATE tablename SET fieldname=True WHERE ..."

The WHERE clause would be the criteria used to filter the subform records.