Clearing tick boxes

[VAA]

Can anyone show how to clear selected tick boxes by means of a query?

Thanks

 

[sfreeman@co.mer]

Like this?

One way to do it:

Assuming that you have a table [tblticks], upon which you base a form [frmClearTick], that contains 3 fields [TickID] [Tick1] and [Tick2]

The query would be something like:

UPDATE
tblticks

SET
tblticks.Tick1 = 0
, tblticks.Tick2 = 0

WHERE
(((tblticks.TickID)=[Forms]![frmClearTick]![TickID]));

HTH

 

[modest]

Is the ticks based on a table or do you want to set them on the form?

 

[VAA]

the tick(check) boxes are in the table and accessible on a form as well. I am looking for way to clear selections by running a query rather than unchecking each item individually.

Thanks

 

[Sergeant]

You could build an update query. Type "update query" into Access Help, and you should get detailed instructions. Set the field's "Update to" to False. Push the run button or run it from code like DoCmd.OpenQuery "MyUpdateQuery".