Clear Yes/No field in form with a command button (1 Viewer)

[JimFlood2424]

I have a Yes/No field in a form for selecting the record. I would like to have a command button that would reset (clear the check mark) in all the records.
Does anyone know if this can be done?

 

[June7]

CurrentDb.Execute "UPDATE table SET field = False"

Is this a multi-user database? Multiple simultaneous users will conflict.

 

[tvanstiphout]

CurrentDb.Execute "UPDATE table SET field = False"

Is this a multi-user database? Multiple simultaneous users will conflict.

> Is this a multi-user database? Multiple simultaneous users will conflict.
Can you explain that more? What conflict would you expect, and how would you guard against it?

 

[June7]

If multiple users are simultaneously checking and unchecking field in table, they are in conflict and output will be wrong for everyone. Arbitrary selection of records is seldom efficient or practical. Selection is normally based on criteria like date range or zip code, etc. Review http://allenbrowne.com/ser-62.html

 

[JimFlood2424]

Not a multiple user database. Thanks going to try your solution.

 

[MajP]

There are some other approaches for recording selections without requiring a field in a table.

Solved - How to add a checkbox on a Continuous Form

Hi; I am trying to add a checkbox on a continuous form in order to select "employees" that I will send an Email to them. the data (on the continuous form) comes from query, now if I checked or unchecked the checkbox on the form detail, all of them will have the same behavior. I don't want to...

www.access-programmers.co.uk