Select all checkboxes

[Sniper-BoOyA-]

Good Afternoon,

I am working on a (continious) form with checkboxes. The checkboxes are stored in a table.

What i want to do, is add a checkbox on the top of the form, and if the user clicks/checks it, then all checkboxes should be checked.

The checkbox in the table is called "thrownaway" and the checkbox on the form is called "Checkbox".

Ive treid to put this in the afterupdate event, which results in the first checkbox to be checked..

If me.checkbox=True then me.thrownaway=true else me.thrownaway=False

Any ideas?

Cheers.

 

[Sniper-BoOyA-]

Well, i think im getting somewhere.

I made an UPDATE query to update tablename.thrownaway.

I guess all theres left for me to do is to make sure the update query runs when checkbox=True, and make sure it does a requery after that.

Ill keep you posted.

 

[boblarson]

Well, i think im getting somewhere.

I made an UPDATE query to update tablename.thrownaway.

I guess all theres left for me to do is to make sure the update query runs when checkbox=True, and make sure it does a requery after that.

Ill keep you posted.

That would have been my advice on how to do it.

 

[Sniper-BoOyA-]

That would have been my advice on how to do it.

Well it worked like a charm. Thanks bob!