Basic syntax to check for duplicates using Dcount

[elmop2005]

what would the basic syntax be to check for duplicates in a form. the field that need to be checked is called ProductID

 

[John Big Booty]

Try;

If DCount ( "ProductID", YourTable", "ProductID = " & Me.ProductID) > 1 Then
     MsgBox "This current record is a Duplicate"
End If