Yes its a syntax issue and you need to have the Recordset open to execute the SQL.