Automatically uncheck all records in Check box field.

[Cam]

Hello,

I have a database table with a Yes/No field
called "Pulled". I would check (Yes) the records that I
want to include in a printout. Each time is different
records. I created a form in Edit View with all the
records and just check the records I want to include.

I would like to create a command macro so when click, it
will set all the records in the Pulled field to No
(uncheck). I don't know how. Thanks for any help.

 

[Jim/Chris]

Run an update query that updates the check box to no based
on the same criteria used in the report

Jim

 

[Amanda]

Good Afternoon,

Try creating an update query that unchecks the boxes.
Qreate a query based on your checkbox table. In the design
view change the query type to update query. Than in the
update to row under your checkbox field type 0 and in the
criteria field type -1. Every time you run the query it
should uncheck the boxes. Than you can make a macro that
runs this query.

Amanda