Updating field from checkbox action on form 1

[MontgomeryPete]

I am attempting to update a field when a checkbox is checked. I am using Office 2007 and VBA. This seems like such a simple subroutine, but when I run this code:

Private Sub TimeDispatched_BeforeUpdate(Cancel As Integer)
If Me.Dispatched= True, Me.TimeDispatched=time()
Else Me.Dispached=False, Me.TimeDispatched=Null
Endif
End Sub

The field [TimeDispatched] is not updated.


Any thoughts? Thanks, in advance for your help.

 

[PHV]

Your code isn't VBA (or with few syntax errors ...)
What about this ?
Private Sub TimeDispatched_BeforeUpdate(Cancel As Integer)
If Me!Dispatched = True Then
Me!TimeDispatched = Now
Else
Me!TimeDispatched = Null
End If
End Sub

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MontgomeryPete]

Thanks for the prompt response. Your code works just fine. Sorry about the VBA confusion--got in too much of a hurry.

Pete