Check all check boxes in a continuous form

[Danny Morales]

Hello Everyone,

I need help checking all check boxes in a continuous form.

This form has filtered data from its table. I want to be able to set
all check boxes within the form to TRUE but only for the records
reflected on the form, not the whole table.

Please help!!!

Danny

 

[Jeff Boyce]

Danny

Records (rows of data) in Access are stored in tables, not forms.

If you are saying you need to update all the rows in a table (by checking
one/more checkboxes), use an update query. CAUTION: save a backup copy
before performing the update!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Hello Everyone,

I need help checking all check boxes in a continuous form.

This form has filtered data from its table. I want to be able to set
all check boxes within the form to TRUE but only for the records
reflected on the form, not the whole table.

Use an Update query, using the same criteria as that used for the form's
recordsource.

John W. Vinson [MVP]