Fellas,
This is driving me nuts & despite searching I can't get it. I have very similar code in other forms which updates numbers and text variables to the underlying table but I can't get this one which updates the time (short time) to work. I am pretty sure that it is a formatting issue but can't see what
Thanks,
Oscar
This is driving me nuts & despite searching I can't get it. I have very similar code in other forms which updates numbers and text variables to the underlying table but I can't get this one which updates the time (short time) to work. I am pretty sure that it is a formatting issue but can't see what

Code:
'Updates the Ops Log with new Start & Stop times
strSQL = "UPDATE Ops_Log_Table SET " & _
"StartTime = # & Me.StartTime & # ," & _
"StopTime = # & Me.StopTime & # " & _
"WHERE Request_DTG = '" & Me.Request_DTG & "'" & _
"AND Unit = '" & Me.Unit & "'"
DoCmd.RunSQL strSQL
Thanks,
Oscar