Checkbox to update date field

  • Thread starter Thread starter djbolduc
  • Start date Start date
D

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?
 
I usually use the Click event of a CheckBox rather than the AfterUpdate event.
What code are you using?
 
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
Click to expand...

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
 
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?
Click to expand...
[quoted text clipped - 11 lines]
Message posted via AccessMonster.comhttp://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200801/1
Click to expand...

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
Click to expand...
 
Back
Top