I have an access form for adding new vendors. The vendor number is not autonumber it is just a text box. When adding new vendors I get errors if the ID already exists. How can I Check after update of the text box if the ID already exists in the source table?