Help with "INSERT INTO" statement 1

[dpav29]

Hi,

I am attempting to write fields from a form and sub/sub forms to antoher table. I can make it work with numeric values, but not with text. I've tried various combinations like 'text' and "'text'", but can't get it to work. The way it is below, i get an "enter parameter value" popup on that third (Notes) field. what am i doing wrong?

DoCmd.RunSQL ("INSERT INTO [Responses](DistributorID,SubQuestionID,ResponseNumber,Notes)
VALUES (" & Forms![frmActualSurvey].Form![DistributorID] & ",
" & Forms![frmActualSurvey]![frmMainSurveyQuestions]![sbfrmSubQuestions].Form![QuestionID] & ",
" & Forms![frmActualSurvey]![frmMainSurveyQuestions]![sbfrmSubQuestions].Form![Response] & ",
" & Forms![frmActualSurvey]![frmMainSurveyQuestions]![sbfrmSubQuestions].Form![Notes] & ");")

 

[PHV]

[tt]...
[!]'[/!]" & Forms![frmActualSurvey]![frmMainSurveyQuestions]![sbfrmSubQuestions].Form![Notes] & "[!]'[/!]);")[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886