Uncheck box if date is updated

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

Guest

I'm full of questions today :)
I have a Date Completed field (date format) and a Awaiting Signature field
(which is a check box). I would like to know if there is a way to
automatically have the awaiting signature box "uncheck" once the date
completed field is updated? I'm not that knowledgeable about code or macros
so any detailed help would be greatly appreciated. Thanks.
 
Hi,
do this on the form level...on the after update event of a textbox control
which is bound to your date field you could use something like this:

If Me.YourControl <> Me.YourControl.OldValue Then
Me.YourCheckBox = False
End If

YourCheckBox would be bound to the yes/no field of your table.
HTH
Good luck
 
Thanks for your help. I'm missing something because it isn't working.
Here's what I've done. I right clicked on the box for Date
Completed/Implemented and under Properties selected Code Builder on After
Update. I then typed the below code.

If Me.[Date Completed/Implemented] <> Me.[Date
Completed/Implemented].OldValue Then
Me.[Awaiting Signature] = False
End If

FYI - I want the Awaiting Signature (check box) to update after the user has
put a date in the Date Completed/Implemented field.

I know it's user error but if you could possibly point out my errors I would
appreciate it. Thank you again!!
 
Back
Top