Duplicate Checking

A

Annmarie

I am searching for software that will signal when a duplicate entry is being input into certain fields in a form. Any suggestions?
Thanks.
 
A

Adrian Jansen

In the table used as the record source, set the field(s) to indexed - no
duplicates. Then the database does it for you automatically.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
Annmarie said:
I am searching for software that will signal when a duplicate entry is
Click to expand...
being input into certain fields in a form. Any suggestions?
 
K

Ken Snell

A generic answer to your question would be to use the BeforeUpdate event of
each control (not field) on the form (or use the form's BeforeUpdate event)
to do this validation. If you can provide more details, someone can assist
you with more specific suggestions.

--
Ken Snell
<MS ACCESS MVP>

Annmarie said:
I am searching for software that will signal when a duplicate entry is
Click to expand...
being input into certain fields in a form. Any suggestions?
 

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

Repeated phrases wildcard? 1
Duplicate entry in a column/row 14
I have lost 6 months work, how can i get my file back 1
Formating bolded text exclusively. 0
Page numbering with Merged Document and IF statements 1
Split form 0
Recover Outlook calendar entry 1
Copy previous record into form field 0

Top