you can not go to the specified record

  • Thread starter Thread starter Eugene
  • Start date Start date
E

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