Problem of Overwriting in a Table

[nofar]

Hi all,

I have a form that has a subform called "Work order" in this form I have a combo box that looks in the table called "MFG", so for every MFG that I choose from the combobox I can enter many information in the subform.

The problem now that if I have a new MFG that does not exists in the table, It will not appear in the combobox. to solve the problem I added a button that opens a new form to be able to write the new MFG and a button leads back to the "work order" form. However, the new MFG entered in the form overwrite the first MFG in the combobox and I don't understand why

Can someone help me plz or show me a different way of functioning.

Thank you!

 

[GinaWhipp]

Would help if we could see the code you are using to add the new MFG.

 

[nofar]

Thnak you for your help but I made the form when I enter the new MFG data entry = YES et it solved the problem
thx

 

[GinaWhipp]

Okay, glad you worked that out!