custom error message

[msasan1367]

how to create custom error message for duplicate data?


I want this custom message at text box before_update event not at form_error

[orange]

In before update event, use a dcount() to see if there is already a record with this data.
If Dcount >0 then, duplicate would be created.

use MsgBox "Your custom error message here",

For dcount info see