The ONLY time I would use a recordset would be if I had to look at the content of the record to make a decision before doing the update. Otherwise, it would be an UPDATE query every time. And even then, if there is a way to write the WHERE clause to exclude the issue of the decision, then I would use the SQL anyway.