how to reset a group of yes no records to no

E

Ed

I have 37 records with a field yes/no and I need to set all these fields back
to no. I need to have this done automatically.

Please help
 
D

Duane Hookom

This is about as automatic as it gets:
DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE tblNoNameGiven SET SomeFieldName = 0"
DoCmd.SetWarnings True
 
B

bob

I am not entirely sure what "automatically" means, but you could
"automatically" run an update query from code or a macro......
 
Top