Multiple Tabs - Same Table as Record Source- Problem Saving

[dmon000]

HI,

I have an existing form with 5 tabs with 5 subforms. The form is related to the subforms in each case by a field called Prod_Id_No.
This field is a key field in all the tables behind these forms and subforms. Tab 2 and 3 use the same table, NP_Part, as the record source. When I move off tab 3 in this existing form there is no problem.

However, I made a copy of the form and the subforms in order to add fields and controls. In this copy, when I move off tab 3, Access generate an error message about creating duplicate records in a key field. Now this must be because when I am moving off tab 3, Access is attempting to write the same value to the Prod_Id_Field.

I just cant see why the existing form does not have that problem. I looked at all the code behind both the new and the existing forms and can't figure out what the BLEEP is happening or not happening in my copy.

Any Ideas???

Thanks !!!

 

[seaport]

For the copy you made, did you make the "Data Entry" property to be "True"?

Seaport