I have a table where ID# is unique. ON form, if a duplicate ID# is attempted, the record is not written to table, but no indication is given to user that the record was not written. How can I let user know they attempted a duplicate entry?
Write a function that checks the table for the ID# that is typed on the form. Have the function return a user friendly message if the value exists. Call the function on exiting the form's ID# field. Return the focus to the ID# field.