I have a form that is based on a table called survey. The table has several fields the one I need to update are surveyID and date.I need to update the table while the form is open. I 'm trying to use the INSERT TO stmt
Dim letterdate As String
letterdate = Date
CurrentDb.Execute "INSERT INTO survey (SurveyID,date)" & _
" Values (1, 'letterdate')"
If I just do the surveyID it works great. But if I add the date to the statement I get a syntax error. I have tried different editing combs but no luck.
Any help would be helpful.