boblarson,
I tried what you suggested, but I still get the same run-time error:
sqlString = "INSERT INTO tbl_Str_and_Signal_Temp (SIG_ID, SIG_NAME, STR_NUMBER, CHECK_BOX) VALUES([tbl_Engineering_Signal_List].SIG_ID,[tbl_Engineering_Signal_List].[NAME], '" & strNumber & "', 'NO') WHERE...