I have a form frmAssign that is based on a query MyAssign. Within this form is a clickable field that will open another form based on a query of the item in the clickable field. This additional form allows the user to insert additional comments on the item. The problem is when I save and close this additional form and then add additional data and save the original form I get an error that says I cannot save because it would create duplicate values in the primary field. Does anyone have any ideas on this?