Reset All Check boxes

[weircolin]

Hi there

I have a form where I have a subform view in it showing a table. One
of the columns on the table has a checkbox. Is there anyway I can
reset all the checkboxes in a particular column so they are all "No" by
clicking a button?

Thanks

Colin

 

[Jeff L]

Yes.
Docmd.RunSql "Update YourTableName Set YourColumnName = No;"

 

[weircolin]

Ideal, thanks!!

Is there anyway you could tell me how I could get a message coming up
to say something like.

"This will reset column, are you sure?"

Then Yes and No buttons?

Thanks again,

Colin

 

[Jeff L]

Sure.

If Msgbox("This will reset column. Are you sure?", vbYesNo) = vbyes
Then
Docmd.RunSql "Update YourTableName Set YourColumnName = No;"
End If

 

[weircolin]

Thanks Jeff

After I had posted that I noticed that Access asks a question similar
anyway.

Cheers

Colin