Deleting the Values in A Field for All Records

[DD]

Hi,

I have an Access DB, for which I have created a form.
On the form I have a checkbox control. I would like to create a
button on my form that would clear the check from the checkbox for all
records.

I am not sure how to do this any help would be greatly appreciated

Thanks

[tina]

if the form is bound to a table, and the checkbox control is bound to a
Yes/No field in that table, then in the command button's Click event
procedure, you can run an Update query to change the value of the field from
True (checked) to False (un-checked), as

CurrentDb.Execute "UPDATE TableName " _
& "SET FieldName = False", dbFailOnError
Me.Requery

substitute the correct table name and field name, of course.

hth
"DD" <dr*****@cinci.rr.comwrote in message
news:26********************************@4ax.com...

Hi,

I have an Access DB, for which I have created a form.
On the form I have a checkbox control. I would like to create a
button on my form that would clear the check from the checkbox for all
records.

I am not sure how to do this any help would be greatly appreciated

Thanks

[DD]

Thank you very much!!

On Sun, 02 Jul 2006 04:27:15 GMT, "tina" <no****@address.comwrote:

>if the form is bound to a table, and the checkbox control is bound to a
Yes/No field in that table, then in the command button's Click event
procedure, you can run an Update query to change the value of the field from
True (checked) to False (un-checked), as

CurrentDb.Execute "UPDATE TableName " _
& "SET FieldName = False", dbFailOnError
Me.Requery

substitute the correct table name and field name, of course.

hth

[tina]

you're welcome :)
"DD" <dr*****@cinci.rr.comwrote in message
news:4j********************************@4ax.com...

Thank you very much!!

On Sun, 02 Jul 2006 04:27:15 GMT, "tina" <no****@address.comwrote:

if the form is bound to a table, and the checkbox control is bound to a
Yes/No field in that table, then in the command button's Click event
procedure, you can run an Update query to change the value of the field

from

True (checked) to False (un-checked), as

CurrentDb.Execute "UPDATE TableName " _
& "SET FieldName = False", dbFailOnError
Me.Requery

substitute the correct table name and field name, of course.

hth