Ok small problem,
I have a subform with the field ChildID, and i need some code so that it is not possible to select the same value for ChildID more than once in the form. I have attached a image of what i am talking about, the highlighted fields show what i want the end user to not be able to...