re-setting check marks to null

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there

I have a continous subform which users can place a check mark beside one or many options. I want to have a button that is a "Clear All" which clears all the selections the user has made

Can anyone help me

Thanks in advance

Carlee :)
 
Hi there,

I have a continous subform which users can place a check mark beside one or many options. I want to have a button that is a "Clear All" which clears all the selections the user has made.

Can anyone help me?

Thanks in advance,

Carlee :)
Click to expand...

If the check marks are bound to the table, add a command button to a
form (in the Header or Footer).
Code it's Click event:
CurrentDb.Execute "Update YourTable Set YourTable.CheckBoxName = 0;",
dbFailOnError
 
Carlee,

I just did something similar to what you're trying...
I'm more familiar with Macros, so I wrote a macro that
runs an update query, then does a refresh on the form.

Cathy
-----Original Message-----
Hi there,

I have a continous subform which users can place a check
Click to expand...
mark beside one or many options. I want to have a button
that is a "Clear All" which clears all the selections the
user has made.
 
Back
Top