First I am doing this with a subform.<br>I have parent tbl1report linked to childtbl2report and childtbl2notes. I am trying not to have duplicate records in childtbl2notes for each parent. Any one have code that works with its own message box to stop duplicate records in this area only. Thank you in advance for any ones help!