"Clear" selection in a form or table

[mrsbean]

Is there any way of automatically "checking" check boxes on a number of records (eg with a Find and Replace type of macro), and then "unchecking" all check boxes on a form? Please help, bearing in mind my programming skills are almost non-existent! Thanks.

 

[AlienRay]

Unchecking multiple records can be done easily by executing an Update Query.

Unchecking check boxes on a form is easily done in code, along the lines of:
Me.Check1=0
Me.Check2=0
Me.Check3=0
etc.

 

[mrsbean]

thanks, now I know what an update query does as well!