I have created a trigger that raises an error if the wrong kind of client type is input. I want to send this message to access (my front-end) after I save the entry. It`s not working. I get "ODBC - insert on linked table failed". After I escape and close the form...THEN I get my user defined error from sql.

What am I doing wrong?