Originally Posted by
June7
Put Now() in the UpdateTo row under the relevant field. Or use only VBA instead of query object.
CurrentDb.Execute "UPDATE EEJobHist SET JobEndDate = Now() WHERE JobEndDate Is Null AND EmpID = " & Me.EmpID;
Not to derail or hi-jack the thread but this leads me to a question I've wondered about before: Is there any reason I should be doing something like
Code:
Dim db AS DAO.Database
Set db = CurrentDb
db.execute "...", dbFailOnError
db.close
set db = nothing
vs the simple one liner you proposed:
Code:
CurrentDb.execute "...", dbFailOnError