Find Duplicates and Notify User

  • Thread starter Thread starter Carl Johnman
  • Start date Start date
C

Carl Johnman

Can someone please help me display a notification message
(pop up or in another text field on form) when the user
enters a address that has been previously entered into the
table possibly 2 or more times.If possible it would also
help to immediately show these records.

Thanks,
Carl Johnman
 
Have a look at the DCount function in help. You could test if the result of
this call is >0 and if it is then go get the duplicate records and display
them somehow.

HTH
Sam
 
Back
Top