How to avoid sql-server error after update?

[fmientjes]

I have a form based on a SQL-server table. In the table you cannot enter duplicate keys (e.g. debtornr).

I want to display a neat message when someone enters the same debtornr. The current SQL-server message looks quit frightening to a lot of users.

Which event do I have to trigger? I tried several ones, also tried to break in the message, but no results yet.

Can someone help me out?

Thanks,
Frans

 

[hneal98]

You would not trigger an event, but you would need to trap the errors using the On Error Goto clause. you can look that up in Access help.

 

[fmientjes]

Thanks,

But where should the on error statement be?
On form_open event?

I cannot get the right trigger / event.
Do you know?

Frans

 

[PHV]

Have a look at the Error event of the Form object.
Another way is to play with the DLookUp function in the BeforeUpdate event procedure of the debtornr control.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886