Trap this error

[ansentry]

If you open the attached sample you will see what my problem is.

I have Form /Subform with look up combo that will not allow duplicate entries in same subform record. This works fine, access displays an error when a duplicate has been added as it should. What I want to do is trap that error myself and display a msgbox that will allow the entry to undo (the msgbox undo etc I can handle, it the trapping of the error)


Thanks in advance.

 

[MStef]

Hello John A!
here it is

 

[ansentry]

MStef,


Thank you * 10,000 times.

I found your code, I will change the message to suit.

How did you know what error code number to use? I did a google and did not find a site that gives me a list of the errors and their numbers.

 

[ghudson]

MStef,
How did you know what error code number to use? I did a google and did not find a site that gives me a list of the errors and their numbers.

Check out the accessandjeterrors.zip sample I posted @ Error Messages - GO AWAY

 

[ansentry]

ghudson,

Thank you for the advice etc