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.
If you're entering data directly into a Table...
DON'T.
Table datasheets are very limited. The function of a Table is data storage,
not data entry or searching or display. You can do some of these operations in
tables, but only in a "quick and dirty", very limited way.
You are better off using a Form to enter data. You can use tools like combo
boxes or listboxes on a form to display and select existing values; you can
also put "Before Update" events on a textbox to use DLookUp to check for a
duplicate, and can warn the user and cancel the entry if it finds one. Tables
don't have such events.