Define a BeforeUpdate event on the control (in the form) where the user will
input the data. Within the event's VBA code, perform a Dcount on that field
in the database to see if it's already there (and how many times, if that's
important to know). Issue a message if > 0.
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.