I am using a yes/no field to select a number of records for a report. Is it possible to deselect and turn them all back to no at one time when finished with the report. It would be nice if I did not need to deselect all of them individually.
Thanks,
Novice
Windows 7 64bit 
Access 2010 64bit
I am using a yes/no field to select a number of records for a report. Is it possible to deselect and turn them all back to no at one time when finished with the report. It would be nice if I did not need to deselect all of them individually.
Thanks,
VIP
Windows 7 64bit Access 2010 32bit
Could run an UPDATE sql action.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 64bit Access 2010 64bit
What would the code for that be?
VIP
Windows 7 64bit Access 2010 32bit
Like:
CurrentDb.Execute "UPDATE tablename SET fieldname=No"
The trick is figuring out what event to put the code in.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Filter Form with Multiple Check Boxes
To check or Un-Check all Boxes in a form
Posting Permissions
Reply With Quote