Duplicate records

[JayBall]

I need to setup some code which looks for duplicates when records are entered. If the first line of an address matches I need it to flag up a message box. Any ideas?

Thanks, Jason.

 

[DougP]

Yeah create a dulpicate Query using the wizard and past that SQL Statement into your VBA code. Let Access work for you. DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[UncleJack]

In the After Update event of your address1 text box, put something like this:

If Me!Address1 = DLookup("Address1", "AddressTable&quot then
Msgbox "Duplicate address being entered."
End if

Uncle Jack

 

[Edimator]

Try setting the "Validation Rule" for the Address1 text field, with the code dlookup("[Address1]", "AddressTable", "[Address1] = " & [Address1]) Is Null

and the "Validation Text" like "Address Found! Try another one"

*** The final "Is Null" is separated by a single space. That´s is different that "IsNull". Both are functional but with different results.