checkbox mania...

[Guest]

Hi,

I have main form with a subform. this subform is a continous form type
date sheet. I have implemented code that allows a user to multiple select
checkboxes in the continous form by using a collection of checkboxes.
this works great.

I have a button on the main form that says: Select All.
When a user presses this button I would like all the checkboxes (one
checkbox for each record) to automatically be checked and added to the
collection with the recordid I have in another field.

I'm kind of lost as to the approach to use.

Does anyone have any ideas?

P.S: I know how to remove all the checks. set checkboxcollection = nothing and
requery the subform.

thanks

Chris

 

[Ian Davies]

Wouldnt it be

set checkboxcollection = true

 

[Guest]

I need to be able to hold the recordids (one of the fields) as the value
for each checkbox in the collection.

 

[Ian Davies]

A check box can only hold the values true or false (Boolean)
Im not very clear on what you want to do exactly. But I think you may need
to bind the checkbox to a boolean field in the same table where recordid
is. You can then have your button to run an update query to change the
values of the boolean field in your records and hence the bound check box on
your form. you will need to requery to show the changes on your form.

Ian