@nbcrockettauthorJan 17.2007 — #I can't do that. I'm using the data in the recordset for something. Once I've used the data in the recordset I want to delete it. Should I just close the recordset then reopen it using DELETE instead of SELECT? I'd rather not, I've already got a dozen recordsets opening and closing on this page.