You can do this from the table side instead of VB
if you want.
In the design view set the "indexed" property of that field to "Yes (No Duplicates)"
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!