Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    4

    Unanswered: Checking duplicate records ACCESS platform

    How can I check record before I updated it if is a double.
    I want to check for example also by first name and last name and by phone ... And if I have a duplicate record, that it will give me a message to see if I really wanted it twice ...

    Thanks to all the helpers ...

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Code:
    If DCount("*", "Name of the table or query", "[first name] = '" & Me.("first name").Value & "'") > 0 Then
        ' --> At least one row exists with the same value in [first name].
    End If
    Use the same for [last name] and [phone].
    Have a nice day!

Posting Permissions

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