Checkbox to update date field

[djbolduc]

OK, I am having a little issue. I created a form and placed a checkbox
on it. I have set and Event Procedure to update my date field on the
After Update. This works perfectly fine until I close Access. When I
reopen the checkbox update does not work any longer. Has anyone else
seen this happen?

 

[ruralguy via AccessMonster.com]

I usually use the Click event of a CheckBox rather than the AfterUpdate event.
What code are you using?

 

[djbolduc]

I usually use the Click event of a CheckBox rather than the AfterUpdate event.
What code are you using?



--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200801/1

I beleve that I tried that and could not get it to work either.

Here is the code I have in the Event Procedure for the After Update:

Private Sub TESTED_COMPLETE_CHK_AfterUpdate()
If TESTED_COMPLETE = "-1" Then
Text97 = Date
End If
End Sub

 

[ruralguy via AccessMonster.com]

Have you tried:
Private Sub TESTED_COMPLETE_CHK_AfterUpdate()
If TESTED_COMPLETE = -1 Then
Me.Text97 = Date
Else
'????
End If
End Sub
True and False fields are numerical fields rather than strings.

I usually use the Click event of a CheckBox rather than the AfterUpdate event.
What code are you using?

[quoted text clipped - 11 lines]

Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200801/1

I beleve that I tried that and could not get it to work either.

Here is the code I have in the Event Procedure for the After Update:

Private Sub TESTED_COMPLETE_CHK_AfterUpdate()
If TESTED_COMPLETE = "-1" Then
Text97 = Date
End If
End Sub