Suppressing Error Messages for Unique Values

[Vincent Koh]

Hi everybody, hope someone can help me.

I have a field(phone field) where I have set it to only unique value input. When I key in data into this field and if the phone no already exist I have this dialogue box popping up that says " (Phone no) is defined to contain unique values only. You must enter a unique value" [Revert] [Ok].

What I want to do is to suppress this message box and prevent it from appearing and using my own custom message box instead. However I don't seems to be able to identify the error codes. When I researched around, there are information indicating that this could be error code 504. But when I tried to capture this error(i.e. Get(LastError)) it returns a 0 value.

Can someone please advise what I can do to suppress this error message?

Thanks.

[Wim Decorte]

You could use the "onValidate" trigger

[Raybaudi]

What I want to do is to suppress this message box and prevent it from appearing and using my own custom message box instead.

Let the OnValidate trigger fire a script like this:

Set Error Capture [ On ]

Go to Next Field

If [ Get ( LastError ) ]

Show Custom Dialog [ "This value isn't unique" ]

Exit Script [ Result: 0 ]

End If

The key of all is the red step.

[Vincent Koh]

Hi Raybaudi, thanks a lot. I tired. But it does not work with the "Go To Next Field". I tired just "Go To Field" without indicating any field to go to and it works just fine. Again thanks!