Autonumber trying to create duplicates

[Gary]

I use an autonumber as my primary key in my table contracts. From the form
contracts users select create new record, enter the contract number and state
and county and then refresh. Sometimes the error message comes up with
trying to create duplicates. When I investigate the contract number which is
a unique field itself there is no duplicate. If I reset the autonumber
everything is fine and the user can add records with no problems. This error
seems to occur randomly and I need help as it is killing productivity.

Thanks

 

[Gina Whipp]

Gary,

Have a look at...

http://allenbrowne.com/ser-40.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I use an autonumber as my primary key in my table contracts. From the form
contracts users select create new record, enter the contract number and
state
and county and then refresh. Sometimes the error message comes up with
trying to create duplicates. When I investigate the contract number which
is
a unique field itself there is no duplicate. If I reset the autonumber
everything is fine and the user can add records with no problems. This
error
seems to occur randomly and I need help as it is killing productivity.

Thanks

 

[De Jager]

I use an autonumber as my primary key in my table contracts. From the form
contracts users select create new record, enter the contract number and
state
and county and then refresh. Sometimes the error message comes up with
trying to create duplicates. When I investigate the contract number which
is
a unique field itself there is no duplicate. If I reset the autonumber
everything is fine and the user can add records with no problems. This
error
seems to occur randomly and I need help as it is killing productivity.

Thanks

 

[joelgeraldine]

vv;:::::