You are somehow runing the function that adds the record twice. Could be that you have a couple ways to execute the function and because of the way your events are linked you run through the code twice.
I see this happen when you link an update via OnChange event on a TextBox for example, then when you change the box it executes the routine,which in turn updates the TextBox with a new value -- which kicks off the OnChange again.
WaltP
Posting Sage w/ dash of thyme
10,492 posts since May 2006
Reputation Points: 3,348
Solved Threads: 943