Hello  Ive both taken and put to use ALZs Calendar Seminar. I used for the most part the field names for my own table and queries from the training videos.  Everything has been working as expected except now when I need to perform an SQL INSERT INTO with an event triggered from a form. The field that seems to be generating the error is the same [DateTime] field used throughout the training. SQL must see that as a reserved word?

(PatientID is a long, DateTimeAdd is dimensioned as a date)
Using the same variables, Im able to successfully enter a record using:
CurrentDb.Execute "INSERT INTO tsh_TempT (PatientID, DateOK) VALUES (" & PatientID & ", #" & DateTimeAdd & "#   )"

But receive an error when I switch to the needed field to DateTime
CurrentDb.Execute "INSERT INTO tsh_TempT (PatientID, DateTime) VALUES (" & PatientID & ", #" & DateTimeAdd & "#   )"

I built a test table and copied the field name from the table into the above statement, when DateTime is used it seems to continue to generate a syntax error. Any suggestions?