Results 1 to 2 of 2

Thread: Duplicate

  1. #1
    Join Date
    Mar 2004

    Unanswered: Duplicate

    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?

  2. #2
    Join Date
    Jan 2003
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts