Hope someone can help,
I have a split form with a combo box on the main form "frmCompany" that populates the forms Company Name and Company Branch and Company ID text box's. The Main and sub form has a Master/Child CompanyID relationship.
The data on the Sub Form saves to "tblProject"
This works well.
The Problem is... Every time I use "save and new" or "save and close" button on the main form, the "frmCompany's" Table "tblCompany" updates with a duplicate Company Name, Branch and ID.
Tried various event snippets, snapshots settings, and cross tab query without success.
To sum up I want to save the new record to the Project table and leave the Company table data unchanged.
Many thanks