470,591 Members | 2,083 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,591 developers. It's quick & easy.

Autonumber in a form creating duplicate values


I have created a form that links with a table with the autonumber feature as its primary key. Whenever i create a new record in the form (using a command button ... i have disabled the navigation buttons) it creates a duplicate primary key value. i.e. it always starts back at 30.

If i go to the table it is temperamental. Sometimes it will create a new record with the next autonumber in the sequence, and the next time it resets to 30. I have tried copying and pasting everything, creating a brand new table, turning the autonumber feature on and off. The problem always returns.

I read about this problem on the microsoft site, they say it can come from compacting a db. However I have not done this (and i am 99% sure my associate has not either). Another post said that the problem could be in the form, however I have yet to find any reference to starting a new record at a set number in the form.

After I recreated the table, (copy pasted) the table always created a new record with the next autonumber, so half the problem is solved, but the form is the main issue.

Any help would be greatly appreciated.


May 10 '07 #1
1 1817
1,923 Expert 1GB
If this link does not resolve your problem, please provide more detailed information about your problem.

May 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

35 posts views Thread by Traci | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.