program adds 2 identical records to table
 

My vb 5.0 program is adding 2 identical records to a table each time I run it. Does anyone know what would cause this?
Thanks

Re: program adds 2 identical records to table
 

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.

Re: program adds 2 identical records to table
 

How can I tell when vb executes something that I don't know about, such as this onchange?