Check all checkboxes in a subform with one command button....

[enuf4u]

I have a form with a subform that shows what inventory items need to be ordered. In order for the database to order my parts, I have to mark a checkbox true for each part I want to order. My question is how can I add a command that will check or uncheck all checkboxes in the subform???

Thanks in advance for any advice!

 

[RoyVidar]

Hi!

This would involve looping thru the subforms recordset, setting the field the checkbox is bound to, to false.

Similar questions are answered before, heres a thread with an approach not far from what you're asking (thread702-736652). Try it out, and report back if problems.

Roy-Vidar