toddsavage100
New member
- Local time
- Yesterday, 18:21
- Joined
- Mar 25, 2007
- Messages
- 2
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 do! Maybe some Onlostfocus code which displays a msgbox when repeating data is entered? Please help its for my coursework and we haven't even been taught VBA, they just expect us to do it! Thanks
Todd
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 do! Maybe some Onlostfocus code which displays a msgbox when repeating data is entered? Please help its for my coursework and we haven't even been taught VBA, they just expect us to do it! Thanks
Todd
