Strange Behavior adding Records

[RickCaird]

My client wants a data entry application, but he wants the previously entered data to remain on the screen since he usually only wants to change a couple of the data fields. So, I created a form (.mdb) and add the record via vba code.

I have the autonum field turned on and have set the form parameters to:

edit = no
delete = no
additions = yes
Data Entry = yes

Now, say the next autonum should be 50. When I add a record, the autonum used is 51 and as I continue adding records, the autonum increases properly. However, when I close the form (via the X or via a close button) record number 50 is created with the exact data in the last record added.

I can filter this out with a distinct query, but I really don't want this data and so far I have been unable to stop this from happening.

Does anyone have any idea as to what is really going on here?

 

[RickCaird]

Never mind, I found the problem. I had the form bound to the table. I just took the binding off and I am no longer getting those duplicate records.