Access doesn't fcheck for some constraint violations until after it tries to
save the record.

You could have Access check if you used a form. You could do something like
a DLookup on an event like On Exit.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"LORENZO" wrote:

i have 8 columns and the first is title. when i enter a title that is already
in my list, why do i have to go through the other 7 to get a notice that the
title is already on file? thanks for any help.
--
LORENZO