Autonumber trying to create duplicates

  • Thread starter Thread starter Gary
  • Start date Start date
G

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
 
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
 
Gary said:
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
Click to expand...
 
Back
Top