How Can I Check for Duplicates - But Allow Them

[Melaz29]

I have a database called "Main" containing customer details and interactions.

One of the fields is the "Customer Number", whilst I know I can index the field to stop duplicates, is there a way to check for duplicates when entering the customer numbers into the form and display a warning message as opposed to just rejecting the entry? There are occassions I need to create multiple entries but would like to be notified.

Here's hoping....

 

[RuralGuy]

Use DLookup() or DCount() in the BeforeUpdate event of the control.

 

[Melaz29]

How do I build the warning box?

Ta...reading the dcount stuff now...

How do I build the warning box into it so it will appear if there is a multiple record in response to the dcount()???

 

[RuralGuy]

If Not IsNull(DCount....) Then
MsgBox "......"
End If