Hi guys,

I am not a VBA programmer, but am trying to help someone out with their database. They have a simple form to add contacts to their contacts table.

I have created the below code that will identify duplicates based on the first name and surname. Ideally, it should be the first initial and surname. I have suggested postcode, but they don't really use postcodes.

At the moment this code will match...