Select All in a continous form

[figueroafredy30]

Hi, i'm having dificulties solving this problem. i have a main form in
which you can filter data based on the criteria, then the data (w/the
check box on every record) will be listed in a continous form. here is
the problem, i need to put a check box which if it's set to true then
all the check box in a filtered data will be set to true, then if i
uncheck it will deselect all the checked records. i got a little
knowledge in VB but i can't figure it out. any suggestions or comments
will be appreciated! thanks a lot!

 

[John W. Vinson]

Hi, i'm having dificulties solving this problem. i have a main form in
which you can filter data based on the criteria, then the data (w/the
check box on every record) will be listed in a continous form. here is
the problem, i need to put a check box which if it's set to true then
all the check box in a filtered data will be set to true, then if i
uncheck it will deselect all the checked records. i got a little
knowledge in VB but i can't figure it out. any suggestions or comments
will be appreciated! thanks a lot!

Use the afterupdate event of an unbound "all" checkbox to run an Update Query,
updating the yes/no fields in the table, using appropriate criteria.

Don't forget - data is not stored in Forms; the continuous Form does NOT have
multiple checkboxes. It has *one* checkbox displayed in multiple instances;
the actual yes/no values are stored in a table, the form's Recordsource.

 

[figueroafredy30]

Use the afterupdate event of an unbound "all"checkboxto run an Update Query,
updating the yes/no fields in the table, using appropriate criteria.

Don't forget - data is not stored in Forms; the continuous Form does NOT have
multiple checkboxes. It has *one*checkboxdisplayed in multiple instances;
the actual yes/no values are stored in a table, the form's Recordsource.

ok thanks a lot, i will try it out.