M
Michelle Taylor
Thank you very much. That was exactly it 
-----Original Message-----
The demon is ADO vs DAO
Make this change:
Dim rstTemp As DAO.Recordset
You may need to check your references but I think you have
DAO references (as well as ADO) because otherwise it would
bomb out on the line before (Dim dbs As Database)
.