<div>
I provided the wrong info. &nbsp;I actually have to check for a duplicate record using first and last name. &nbsp;Here is my before update code but the warning is not appearing: &nbsp;(now what am I doing wrong?)<br />
<br />
&nbsp; &nbsp; If DCount(&quot;*&quot;, &quot;Member Table&quot;, &quot;MemberFirstName = '&quot; &amp;&nbsp;Me.txtMemberFirstName &amp;&nbsp;&quot;' AND MemberLastName = '&quot; &amp;&nbsp;Me.txtMemberLastName &amp;&nbsp;&quot;'&quot;) &gt;&nbsp;0 Then<br />
&nbsp; &nbsp; &nbsp; &nbsp; MsgBox &quot;There is already a member in the database with this name.&quot;, vbOKOnly<br />
&nbsp; &nbsp; End If
</div>


I provided the wrong info.  I actually have to check for a duplicate record using first and last name.  Here is my before update code but the warning is not appearing:  (now what am I doing wrong?)

    If DCount("*", "Member Table", "MemberFirstName = '" & Me.txtMemberFirstName & "' AND MemberLastName = '" & Me.txtMemberLastName & "'") > 0 Then
        MsgBox "There is already a member in the database with this name.", vbOKOnly
    End If

<div>
Never mind. It IS working. &nbsp;Thanks. &nbsp;I do have another question closely related but I'll post another topic.
</div>


Never mind. It IS working.  Thanks.  I do have another question closely related but I'll post another topic.

<div>
<div class="content wysiwyg-content">
I'm trying to alert a user if a name already exists in the database. &nbsp;Something is wrong with this code. &nbsp;Can someone tell me what it is? &nbsp;The syntax is wrong in the first line.<br />
<br />
&nbsp; &nbsp; If DCount(&quot;*&quot;, &quot;Member Table&quot;, &quot;MemberFullName = '&quot; &amp;&nbsp;Me.txtMemberFullName &amp;&nbsp;&quot;') &gt;&nbsp;0 then<br />
&nbsp; &nbsp; &nbsp; &nbsp; MsgBox &quot;There is already a member in the database with this name.&quot;, vbOKOnly<br />
&nbsp; &nbsp; End If
</div>
</div>


I'm trying to alert a user if a name already exists in the database.  Something is wrong with this code.  Can someone tell me what it is?  The syntax is wrong in the first line.

    If DCount("*", "Member Table", "MemberFullName = '" & Me.txtMemberFullName & "') > 0 then
        MsgBox "There is already a member in the database with this name.", vbOKOnly
    End If

Warning if name already exists in database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.