Select all button / checkbox

[IHulky]

Hi everyone,

I'm trying to create a select all button.

The records are shown from top to bottom beneath each other, to mark the status in the database a lot of check boxes are used to create a "control" stadium.

Problem is that when we want to continue with the work 200 records with a checkbox have to be clicked to advance to the next stadium.

I've created serveral test buttons / checkboxes but they only affect the selected record (if the record navigation hasn't been removed it is possible to scroll down and with all the records highlighted to check them all, but this is just a workaround)

Can someone advice on the matter?

Thanks in advance

 

[RuralGuy]

I would use an UPDATE query.

 

[IHulky]

ok, I have read some other forums about that unfortunatly I haven't found a way on how to do it.

Can you push me in the right direction?

 

[RuralGuy]

Can you use the Query builder to create a select query that will only select the records you are displaying?

 

[IHulky]

The form is based on a query, which shows only the results as displayed.

Do you want me to create another query for that or does this answer your question.

Regards

 

[RuralGuy]

With a different query that selects the same recordset as the subform you can turn that query into an update query for that recordset and set the checkbox field for all of the records the way you want. Then your "Select All" button can just run the query.

 

[IHulky]

Never tried that before, but I will do so tonight.

I'll let you know the outcome, thx