I have a sheet which has a yes no ope box for each client a form is linked to this with a tick box controlled by the yes no option. Is there any way I can have a button once clicked whichwill clear all the tick boxes and make them clear and not selected, I have created one but it only clears the current record and not all the tick boxes for all the records.

Thanks

Two steps.

First, write an update query that does what you want.

Second, create an action button that runs the query. Enable the wizard, it will walk you through the steps.

Just in case you wanted to check, the Button_Click routine should contain a command something like

DoCmd.OpenQuery "{actionqueryname}"