Replace value of Yes/No field in a query for all records at once

[hnhpak]

I have a form(Datasheet view) record list through a query "PTM List" for selected criteria.



In the said Table/Query i have a Yes/No type field [Print_Select], that field appears in the form as check button for each record.

Through this check button i am manually selecting the records for printing Notice/Circular for selected records only.

I have a control button in form header through which i am printing report (Notice/Circular) for the selected records only.

To print print other records I have to deselect all check buttons manually and then select other records manually to print report next time for another selected records.

Up to this level program work properly.

Now I want to add a check button in the form header "Unbounded" or "Bounded with another table yes/No type field [Control].[SelectAll]". Through this check button on After Update I want to replace all values of the field [Print_Select] in the above mentioned query .

I also want to deselect all records by replace value to 0 or False for all records when form open next time by Event on Load or at the time of Closing the from by Event On Close.

I will be grateful if any one can help in this regards.

Regards

Syed Haseeb ul Hasan

[JoeM]

You can use an Update Query to set/reset all the values for a certain field to a specified value.
So, just set up those Update Queries, and add a Command Button which calls on those queries to run them.

[hnhpak]

Thanks JoeM for the help, it works.


Regards
Haseeb ul Hasan