Clearing Check Box in a Table

[sjmojeck]

I am trying to write a macro that will reset check boxes once a report is run.

I have tried the following but none have worked.

Set Value:
[Query]![envelopes].[Value]
=Off

Set Value:
[Query]![envelopes].[Value]
=False

Run Code:
me.checkbox1.value=vbuncheck

 

[Zathras]

Try these:

Option Compare Database
Option Explicit

Sub Uncheck()
  Forms![Form1].Check0 = 0
End Sub

Sub Check()
  Forms![Form1].Check0 = -1
End Sub