i make a enrolment form
i make a button which goto new record
what i did to prevent duplicate entry in the form is in
in Student Number Field, Indexed i put: Yes (No Duplicate)
im searching how to prevent the duplication, raise a custom error message and return the user to the original record...
what my dbase is only in prevent the duplication and error message generated by ms access.
my problem is i want to change to error message example "Duplicate Entry Detected", "you will be taken to the oiginal record" and after proceed to the original record. i dunnu much in VBA...
attached here is my sample dbase...
i make a button which goto new record
what i did to prevent duplicate entry in the form is in
in Student Number Field, Indexed i put: Yes (No Duplicate)
im searching how to prevent the duplication, raise a custom error message and return the user to the original record...
what my dbase is only in prevent the duplication and error message generated by ms access.
my problem is i want to change to error message example "Duplicate Entry Detected", "you will be taken to the oiginal record" and after proceed to the original record. i dunnu much in VBA...
attached here is my sample dbase...
Last edited:
