How do I prevent duplicate entries in a Field?

D

Dave K

Hello. I am trying to prevent entering electrical wiring certificate numbers
more than once. In Table/design view I selected, "Indexed/Yes(no
duplicates)" so I get notificed but by then I've entered data into each field
such as address, phone numbers and about 20 other items. Is there a way I
can get notified of a duplication in a particular field as soon as I tab to
the next...rather than waiting until the whole record is filled? Thanks!
Dave K
 
V

Van T. Dinh

If you use the DatasheetView of the Table, no.

If you use a Form to enter data, you can use the BeforeUpdate Event of the
TextBox which is bound by the WiringCertNo to check whether the entered
WiringCertNo already exists in the Table or not.
 
Top