Duplicate code

[xoymas]

Hi I'm trying to put this code for a form to check duplicate values such as last names but I get a compile error.I have Office2000 rpofessional.Here is the code I tried.
Private Sub State_AfterUpdate()
IfNot IsNull(DLookup("[LastName]", "Customers", "CustomerID=" & Forms!Customers!LastName & "&quot Then MsgBox ("That entry used,blah..&quot
End If

End Sub

I hope anybody can help me thanks

 

[LonnieJohnson]

One thing I see that may be a problem is in the Where part of the DLookup. You are equating an ID to a name. Shouldn't it be either the LastName = the LastName textbox on the form? Also if you are looking for the last name, you will need the tick marks (apostrophe) like so...

("[LastName]", "Customers", "LastName = '" & Forms!Customers!LastName & "'&quot

ljprodev@yahoo.com
ProDev
MS Access Applications