validation rule

[Mik3]

I need to make a validation rule so that a user is not allowed to enter duplicate values in a "tools" table.
How can I make it look in the Tool Name field to search for duplicate values?

 

[Mile-O]

Why don't you just set the field's Indexed property to Yes (No Duplicates)?

 

[Mik3]

coz the error message is too long and might not be very clear for a user - is it possible to customise it?

 

[KingKong]

Mik,

Check this thread on customizing error messages:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36782

Credits go to ghudson.

Grtz,

Peter.