Custom Warning Messages

N

nickels&dimes

I want to have a custom Warning Message pop-up when a duplicate valu
in entered in a text field where duplicate values are allowed

Can anyone help
 
B

Bob Howard

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.
 
Top