>I don't understand completely what you mean.. but if your mean is duplicating codes .. I don't think so.... but it is better for me to hear any idea or suggestion from you that will minimize the code .. and more power ... TQ

The suggestion was to check for existing rows using the Recordset property. I mentioned duplicating code because I didn't see any label where you can resume before the editing code after handling the error on the main body of your example. Do you have the editing code in the error handler too?