This clips will show you the VBA to avoid duplicate entry. There are times that we will input people name with the same first name and Last name and the only different is the middle name. In our to avoid duplicate entry. we need to add full name field with calculated data type in order to concatenate first name , middle name and last time and we will use this vba code after update of the last name. ‪@KamayoAko‬

#shorts #msaccess #vba