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