Autonumber trying to create duplicates

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

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

"Gary" wrote in message
...
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

"Gary" wrote in message
...
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

vv;:::::

"Gary" a écrit dans le message de groupe de
discussion : ...
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