>When I seup database triggers for a table the default 'Trigger Failed' message is fired if the Trigger fails. How can I replace this message with my own message. If I call a function from the trigger to display the message, the default message still fires after my message.

The methods of Edward and Arnon can work very well. But, if you like the simpliest way to do that, you can change the wizstyle class.
I guess you are using the form wizard to create your own form. In your project page, you will find a class which is named wizstyle. Inside this wizstyle class lib, a class named txtbtns is storing the basic function of command buttons. Then, you open this class and check the property window of txtbtns command group(container), you will find out "UPDATEROWS" method. The first few lines "#DEFINE" are the error message you are looking for.

Sunny