Autonumbers AGAIN!

[MS Access confuses me 2]

Hi Gurus,

Please accept my niave understanding of Access, as i am haplessly lost and don't understand as to why the automation of autonumbers is trying to create new numbers even though i have specifed the numbers to be unique.
I get the follwoing error:

" The changes you requested to the table were not successful because they would creat duplicate values in the index, primary key or relationship.2

Again i would very much appreciate if you could help out?

[theaybaras]

Again i would very much appreciate if you could help out?

Can you give us a little more information specific to your situation?
That error message occurs when the value in your primary key field is the same as one already existing in the table. If you are specifying a unique value this shouldn't be an issue. If you can provide more information about your form and table structure(s), we may be able to help you track down the problem.

thanks

theAybaras

[NeoPa]

Hi Gurus,

Please accept my niave understanding of Access, as i am haplessly lost and don't understand as to why the automation of autonumbers is trying to create new numbers even though i have specifed the numbers to be unique.
I get the follwoing error:

" The changes you requested to the table were not successful because they would creat duplicate values in the index, primary key or relationship.2

Again i would very much appreciate if you could help out?

I suspect you're trying to put your own value into an AutoNumber field. It doesn't work that way. ACCESS assigns the AutoNumber values. If you want to be able to put your own numbers in there and keep it unique, just set it to a Number field and make it an index which is unique.