Hello i wonder if you could help me
I have a table called MAIN in this table are yes/no fields called "contacted" and "missed"

I am trying to write a macro that finds all the records that are ticked yes in contacted and missed and then untick all those records to have "no" in those fields

I have made a query that finds the records I would like to change but I cannot seem to get it to set the yes values to no values on all the filtered records

i get an error on the setvalue line saying it cant find the [main]![contacted] which i am trying to set to no instead of yes


any help would be appreciated



Thanks Paul

Why not use an update query? That will do everything you have asked for.

fantastic i tried and found that super easy and works superb

thanks a lot fella :)