I have a continuous form that is used for entering part orders. The field that the user select a part from is a combobox. The field in the orders table is set as Indexed (No Duplicates).
If the user selects a part that has already been selected in another record in the continuous form they get a canned error message that reads "The changes you requested to the table were not successful because they would create duplicate values in the index........" and so forth.
I want to replace that error message with my own message. How can I do this?