Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Duplicate records (Access 2000)

    Duplicate records

    I have a form for entering new products based on the table Products.In order to avoid duplicate codes, i have made the field code in the table to YesNo Duplicates.Neverhteless i want to prevent entering a duplicate code in the code. My form is called NewProducts and the source is the table Products.Can i build some code in the form, giving the message that
    the product will not be entered becasue of an existing duplicate?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Index on more that one field

    --------------
    i have made the field code in the table to YesNo Duplicates
    --------------


    With what you have described you should get a message from Access, Some thing Like:

Posting Permissions

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