Create a directory for every new contact in ms-access and check the existence only with the ID of the contact
I would like to create a new directory for any new contact I enter in an access database but I would like to check the existence of the directory only with the last 4 characters. These last 4 characters are the ID of the contact, so in case someone change the details of the contact (like the name) the form will not create a new directory. For this reason with a field “TxtContactAs” I calculate the name of the directory to something like “John Doe – 0085”