Duplicate Checking

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

Guest

I am searching for software that will signal when a duplicate entry is being input into certain fields in a form. Any suggestions?
Thanks.
 
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?
 
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?
 
Back
Top