you can not go to the specified record

[Eugene]

I have a field set up as index no duplicates. When a duplicate is entered a
system popup appears...

"you can not go to the specified record"

1)is there any way to change that message to something more meaningful?

2) is there a way to test for a duplicate prior to the add record button
being pressed and have a meaningful pup up error message?

Thanks in advance

 

[Maurice]

In that case I always try to trap the form error message and tackle the data
err number. when you have that one you can create your own message based on a
select case statement.

So look for the form_error options in the properties of the form and try
that out by first displaying a messagebox and then try tuning it to your own
delight.