dublicat or not...

[Morten R]

Hei, i need a litle help wit an field in my table.
Is ther a way to give a user a warning if he try to type in a dublicate value. We are regist letters and give them a case noumber, but sometimes people send the same letter more than one tims. Then the same case get to casenoumber. I need a warning thay must click on and say OK. Is this posible??

 

[The_Doc_Man]

If you can establish an index that has attributes "No Duplicates" then a user can enter any value but cannot SAVE any value.

The trick is to massage your data to the point that you CAN establish the index with NO DUP attribute. It is easier AFTER you get there - but getting there is no picnic.

 

[rainman89]

in the before update event u can use a dlookup and dcount to see if there is one that already exists with that name. if it does throw out a msgbox