SQL where子句中的vba访问记录集字段

I have a DAO recordset that loops through a recordset and runs a SQL statement on another table, updating records of that table. For some reason, it doesn't like using the recordset value in the where clause of the SQL statement. I've tried everything I can think of.I have a DAO recordset that loops through a rec