Custom Warning Messages

  • Thread starter Thread starter nickels&dimes
  • Start date Start date
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
 
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.
 
Back
Top