Notification of Duplicate Records

[Velve]

Hi

I am making a database of addresses & postcodes. If I enter a duplicate value onto a form is there any way that I can get notification to say that a record with similar/same information has been entered previously? Also is it possible to show those records with the duplicate info??

Cheers

 

[FoFa]

Yes, and one way to do it is on the before update event (I believe) check the table for those fields you want as duplicates. Typically I check for the duplicates with a count to see if they exist, set a flag (variable or invisble field on form) and cancel the update. Than open a form with a list box of the duplicate/s for selection. If you still want them to be allowed to insert the duplicate data, you would have to account for that also.