title: visual basic adodc - category - multiple record with the same key
body: <p>Well i'm trying to create a form in VB6 to control my database that was created by access, i did everything and everything went perfect,until i notice that if you enter the same "ID" i get an erreur from access that there is multiple Ids with the same number,since i activated the primary key in access so it doesn't allow that,so what i'm trying to do is when the user move from the Id cell to other cell,visual basic scan the id cell first and check if there is no other id with the same number,if it is i need visual basic to prompt me with msgbox that say's there is multiple id with the same number.
  i hope that you understand what i'm trying to say i need a way to do it,just the way to follow.thanks 
  * image :
  <a href="http://i.stack.imgur.com/oqBpI.png" rel="nofollow">http://i.stack.imgur.com/oqBpI.png</a></p>