Upon receiving your database, I saw that the code you were using was your old code with the one change in it. So I copied out of my post, the new code I sent to you to see why it was not working, but it does work. So, if you would copy the entire Sub from the post that I sent to you, and try it, I really think you will find that it works. I don't know if it is because the database, or the recordset, or whatever is not opened and closed and opened and closed, but left open as it is needed. Or just what about the changes I sent to you is causing the routine to work, but it does. The code I got from you in this last mailing did not work when I tried it. But, as I said before, when I copied in the code I had previously sent to you, and ran that code, the routine works.
If it does not work after you copy the routine from my last post, then send me the database again, when my code in there so I can see why my code does not work in your database.
Thanks,
Vic