Help! The following statement causes compile error: expected end of statement

INSERT INTO table1 SELECT * FROM table2 WHERE field = '" & variable & "'