Clearing a check box on Close

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

Guest

I have a table with a yes/no field. I would like the field value to change from a yes to a no when I close the table. Effectively, deselecting the check box associated with the yes/no field on a form.
 
Mary said:
I have a table with a yes/no field. I would like the field value to
change from a yes to a no when I close the table. Effectively,
deselecting the check box associated with the yes/no field on a form.
Click to expand...

Mary,
There is no way to do this if you are in Table view.
However, if you are using a Form, Continuous Form, or Form Datasheet
view, you can place code in the Form's Close event to set the Check Box
field to No:

CurrentDb.Execute "Update YourTable Set YourTable.CheckBoxFieldName =
0;", dbFailOnError

Each time the form is closed, all records will be reset to No.
 
YIPPEE! That worked great Fred. It made my day so much brighter. Happy Holidays!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access problem 0
Access Help with Access 2013 - changing a form field back colour based on another fields entry (Check box) 0
Check List Report 4
Access Dcount (multiple criteria) 3
Access MS access forms list box problems 1
Count Only Yes checks in Access Report 1
Check Box on form 3
Check box value in report 1

Back
Top