I have a form that has RCRA_ID and subform with the RCRA_ID as well. This field is an autonumber. When I open the form, a new RCRA_ID is created in the parent form. Then i go to enter data into the subform that is linked to the parent form with RCRA_ID and when I go to move from that subform it says I have created a duplicate record and can't save. The parent form is using a query with the table tbl_RCRA_Inventory included and the subform uses only the tbl_RCRA_Inventory.

Thanks.