Automatically uncheck all records in Check box field.

  • Thread starter Thread starter Cam
  • Start date Start date
C

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.
 
Run an update query that updates the check box to no based
on the same criteria used in the report

Jim
 
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
 
Back
Top