How do I prevent duplicate entries in a Field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate values 4
Prevent Duplicate Form Entries 0
Preventing entries based on a field 2
Prevent entry of duplicates 4
Duplicate entry for invoices entered 3
Prevent duplicate values in multiple fields 6
do not duplicate date values in form 1
Duplicate Entries in Phone and Email Fields 2

Back
Top