M
Michelle Ives
ACC 97/ XP OS -I saw some quirky behavior yesterday when adding records in a continuous subform and using CTRL+APOSTROPHE (') to copy values from the previous record in some of the fields. When leaving the last field of the new record, it "disappeared", which at first I attributed to a glitch in my form code possibly firing the requery method. I entered several more records, then noticed that the last record on the form appeared to have been duplicated several times (once for each record I had added) with the same autonumber value in the primary key field. I closed the form and went to the table to investigate, and the records I had added were there, and no duplicated autonumbers, of course. This re-occurred a few more times as I added more records, but not everytime. I know this will alarm my users if they experience it, so I'd like to know what could be causing this behavior...