time stamp in table using sql review
dim dCurr as date
dCurr = now()
ttt = me.txtOpened.value
If Forms!nsc_dataentry.txtReOpened.Value <> "" Then
strsql_sql = "INSERT INTO [dbo_t_nsc_trackcode_trans_time_entry](NSC_ID_Ref, [opened_at], InProgress_or_Closed_at)" & vbCrLf
strsql_sql = strsql_sql & "VALUES (" & Me.NSC_Id & ",'" & ttt & "' , '" & dCurr & "');"
CurrentDb.Execute strsql_sql, dbSeeChanges
Does anyone see why this would not time stamp correctly in the "VALUES" part of the statement ?
a better way to use the variable dCurr ?