i think the best solution in this ons is to post a piece of your database and coding in a zip-file. only if you want to ofcourse.

I'm not really sure what you are trying to accomplish and what really is going wrong.

Seems you also forgot to close the rs at the end of the code.

rs.Close
Set rs = Nothing

Using "On Error Goto" is also very important in Database Software developement. You should also consider that.