Modifying data in subform

[daytona]

From a form, I want to be able to click a button which will tick all of the check boxes on all rows of a subform. Can anyone tell me how please?

 

[jfischer]

I'm assuming from your question that these check boxes are bound to a field in table that is displayed by your subform. Here's one way to handle this situation when you click the button:

1) Run a query that updates the check box fields in the table. (The query would need to take into account any record selection criteria that you set up on your main form, e.g., date ranges, department codes.)
2) Requery the subform from the main form.