reseting field to not cause the error "field must be entered"
Hello all
I have a form that tests for duplicate records with a pre-insert trigger. When there is a duplicate record I set each field to null and send a message stating the problem and raise form_trigger_failure. When the user clicks the "OK" button in the message box this all happens.
The cursor is on the first field. When i click the exit button an error comes up that says the field must be entered.
I need to know how to set the field status back to the state where, if the user wants to just exit, they can without the "FIELD MUST BE ENTERED" message coming up.
I have a form that tests for duplicate records with a pre-insert trigger. When there is a duplicate record I set each field to null and send a message stating the problem and raise form_trigger_failure. When the user clicks the "OK" button in the message box this all happens.
The cursor is on the first field. When i click the exit button an error comes up that says the field must be entered.
I need to know how to set the field status back to the state where, if the user wants to just exit, they can without the "FIELD MUST BE ENTERED" message coming up.
0