Find Duplicates and Notify User

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
 
S

Sam

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Actively Find Duplicates On Form 5
Preventing Duplicates from being entered 3
Subform date/time must be greater than date/time of last record 1
text box help needed 3
Test if another user is in same record 2
user name and location 2
Unbound forms and dao recordset question 1

Top