Trouble adding new records

[Lv2valt]

Every time I try to add a new record in my form view it always tells me that it would create a duplicate value of the primary key. I have the primary key set to autoNumber but they are not consecutive numbers because of deletions and such. For adding a new record I have just used the built-in function:
DoCmd.GoToRecord , , acNewRec

Is there anything else I can do?

Thanks

 

[JoeMiller]

I expect that if you look at your table you'll find that you set an index to "Yes (No Duplicates)". This would produce that duplicate error because Access is disallowing you to enter in a duplicate value on one of your indexed fields.

HTH Joe Miller
joe.miller@flotech.net