I can't find out what is wrong with the statement:
sql = "INSERT INTO OPMERKING_PR([gemaakt door], [datum], [notitie]," & _
"[ leadnummer],[werknummer], [navolging]) SELECT " & _
"str1, str2, str3, str4, str5, str6;"
DoCmd.RunSQL sql
str'X' compares with controlboxes in the form, just like
str1 = me.textbox1.value, i.g.
thanx in advance
Gerard
sql = "INSERT INTO OPMERKING_PR([gemaakt door], [datum], [notitie]," & _
"[ leadnummer],[werknummer], [navolging]) SELECT " & _
"str1, str2, str3, str4, str5, str6;"
DoCmd.RunSQL sql
str'X' compares with controlboxes in the form, just like
str1 = me.textbox1.value, i.g.
thanx in advance
Gerard