Hi,
I'm trying to edit an existing record in a table with a date/time stamp once i check my check box on my form. I've been reading tonnes of threads trying to figure out where i'm gonig wrong but i'm yet to have any luck
. I think i'm prettyclose though. Can anyone help?
Thanks
I'm trying to edit an existing record in a table with a date/time stamp once i check my check box on my form. I've been reading tonnes of threads trying to figure out where i'm gonig wrong but i'm yet to have any luck

Code:
Dim TaskHistory As DAO.Recordset
Dim FrmID As String
Set TaskHistory = CurrentDb.OpenRecordset("TblTasks")
FrmID = Me.ID
TaskHistory.FindFirst ("ID = '" & FrmID & "'")
TaskHistory.Edit
TaskHistory("CompleteDate") = Date
TaskHistory("CompleteTime") = Now()
TaskHistory("CompleteUser") = GetUserName()
TaskHistory.Update
Thanks