Clearing checkboxes

P

Pic

My database has a Yes/No field called "Chooser", which I use to select
records when I'm browsing. I then run a query to select all records
that have the chooser field checked.

I'd like to create a macro or query that will clear all those
checkboxes, but can't figure out how to do so. Any suggestions will
be greatly appreciated.

Thanks in advance,
Pic
 
J

john

create a query in design view and add the table that has the 'chooser' field
in it. Then change the query type to update.
then drag the chooser field on the table
Then in the update field type in either 'True' to tick them all or 'False'
To untick them.

Tell me if u hav any other problems
 
S

Steve Schapel

Pic,

Make an Update Query to reset the value of the Chooser field. The SQL
view of such a query would look somethning like this...
UPDATE YourTable SET Chooser=0

If you want to automate this process, you can run the update using a
macro with an OpenQuery action, or a VBA procedure using the
DoCmd.OpenQuery method or the CurrentDb.Execute method.
 
Top