I need VB code to prevent the user from entering the same record twice. Any help would be appreciated

__________________
Mike

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)"

Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!