cheekybuddha
AWF VIP
- Local time
- Today, 23:16
- Joined
- Jul 21, 2014
- Messages
- 2,276
I'm not exactly sure what you're doing here, but see if doing it this way works any better:
Are ID and SerStatus really Text datatype ???
hth,
d
Code:
Private Sub btnFinalise_Click()
With Me
If .Dirty Then .Dirty = False
CurrentDb.Execute "UPDATE dbServis SET " & _
"SerStatus = '-1', " & _
"SerDatum = " & Format(Now, "\#yyyy\-mm\-dd hh:nn:ss\#") & ", " & _
"SerFinishedBy = '" & TempVars("UserName") & "' " & _
"WHERE ID LIKE '" & .txtID & "';"
End With
End Sub
Are ID and SerStatus really Text datatype ???
hth,
d