Hi. I would also prefer using a query, but if you run into problems with delimiters, try using a recordset. Cheers!
Better to sort out the delimiter problem in my opinion
Speed on an indexed table is irrelevant.
Whilst we're all singing from the same hymn sheet, actually that isn't quite true.
Running a SELECT query on an indexed field is certainly much faster - in tests up to 250 times faster
However running action queries on an indexed field will take significantly longer (up to 50% in tests).
This is because the index needs to be updated as well as the individual records.
Nevertheless my previous comments still apply - update queries are faster, the code is cleaner and so are better than using recordsets.
Only use a recordset where it can't be done using an update query / SQL