I apologize if this has already been covered, but I could not find an answer.
I have a form that assigns a quote number (autonumber) and for somereason everytime you enter a new record it enters two. So for every data record there is one empty record.
i.e.
2473 - blank
2474 - has data
2475 - blank
2476 - has data

Thank you for your help.:confused:

It sounds like there is some code somewhere that is adding a record too. You don't by chance have some code in the AfterUpdate event of the form, do you?

There is no afterupdate code. There is an on current to lock some fields.
I am not sure what is happening, and we have since started using some corporate software.
So now I am trying to fix it, just so I know what happened.

One simple way to find out where the error occurs might be to make one of the columns required (and possibly not accept zero length). The Form, section of code etc that is inserting the blank entry will then generate an error. It's a clumsy way of doing it, but it will show you very quickly where the offending code is.