> I have a table named:tbl_BOMinfo
> and I have the a field named: Base_ID as Data type = text
> and I have it Idexed to: Yes (No Duplicates) but at the time to use
> it, it allow the duplicates...( using Forms and Table)
> what is wrong?
It is not indexed as you think it is.
You are not entering duplicates when you think you are.
(you do know it won't give an error until you save, right?)
The file is corrupted.
I think the last is actually not very likely, but you can always tryReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12430Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12430
compact/repair on the file to see if it makes a difference.
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com