Checking for multiple duplicates on save_click

[JaxV]

Hello

I am new to VBA but have had some success creating a user form that enters data into a table on clicking save. What I am struggling with is checking for duplicates and adding a pop up when there are duplicates. I have found some good info on how to do this but not on how to check multiple cells for each record, as I have first name and surname in adjcacent columns and need to check both. I envisage the process to be;

On user clicking save;
Check columns A and B for duplicates within table
If BOTH are duplicated, display message box "this user already exists, do you still wish to save"
If clicks yes, saves record as normal
If no, clears form

This is my existing code for the form when save is clicked (I need to check both Name1TEXT and Name2TEXT for duplicates and only return message box if both are duplicated within the same record. In other words, i'm checking for the full name already existing in my table.

Please Login or Register  to view this content.

Any help would be very much appreciated

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.