Joy,
The Indexed property of the field may be set to "Yes (no duplicates)". You
can check and change this in your table's design view.
hth,
--
Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX
Joy said:
I have a field that won't accept duplicates and it's not a primary key.
How can I change it to accept the same data.