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.
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
duplicates. Then the database does it for you automatically.
--
Regards,
Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
being input into certain fields in a form. Any suggestions?Annmarie said:I am searching for software that will signal when a duplicate entry is
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>
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>
being input into certain fields in a form. Any suggestions?Annmarie said:I am searching for software that will signal when a duplicate entry is