error on changes in mdb

[tselie115]

i am working on ms access forms!
but whenver im trying to change anything it gives me an error that it couldnt save because it would create a duplicate in primary key, indexes..
it comes many times and then the project goes with vb code for application project is corrupted!
wat is goin on? thanks

 

[PaulO]

Sounds like either:-

1. You're creating a NEW record with a reference (that should be unique according to your table definitions) that already exists OR
2. You're amending a record's reference to that of a pre-existing record of the same reference

If, within your table, you have defined this field as an indexed field (yes, no duplicates) this is exactly what will happen when you try and save a second record with the same reference.