I have a simple table with Text [item] and checkbox [Needed]
I would like the table to clear the check box upon opening each time.
Is this possible?
As you can tell I am a complete novice here
I have a simple table with Text [item] and checkbox [Needed]
I would like the table to clear the check box upon opening each time.
Is this possible?
As you can tell I am a complete novice here
Except for data macros, cannot have code behind tables.
Users should not interact with tables and queries. Build forms and reports as user interface.
Code behind a form can run an action SQL to update the checkbox field, example:
CurrentDb.Execute "UPDATE tablename SET fieldname=False"
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.