G
Guest
I have set up a field as indexed with no duplicates. Does anybody know the error code returned by Access 97 so that I can trap it and return an appropriate message to the user?
error code returned by Access 97 so that I can trap it and return anSHIPP said:I have set up a field as indexed with no duplicates. Does anybody know the
Allen Browne said:Yes, it is that simple, except that you cannot trap these errors with normal
VBA error handling, and they are not in Err.Number. The Error event of the
form is less obvious to find, and the DataErr values are not listed (AFAIK).
BTW, TC, you have been posting lots of useful answers for people recently.
Thanks.