>Hi
>
>I am entering a reference no into a text box whose data property is one of the fields on a table. I get the above message when I enter a duplicate key as I have set the index up as candidate.
>
>My question is
>
>How do I trap this error so that I can use normal error handling routines?
Do you use buffering? If you do, you should get no error until you issue TableUpdate() (where it can easily be intercepted), or (in the case of record buffering), move to another record.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)