I Have two tables

tblCustomers
tblDeals

I Have a main for which is linked to "tblCustomers" and a SUBFORM that is linked to "tblDeals" both have a common link to CustomerID from the tblCustomers table, and a One to Many relationship. This is fine; however...

When I open the main form it creates one record in the tblCustomers table and two records in the tblDeals table..ANy one have any suggesstions on the remedy for this..

Thanks

Jeff

Anyone Please...Still Searching!!

Jeff

You must have code somewhere that is dirtying the records and then saving them. This is not standard Access form behaviour. If the subform is properly linked using the master/child link fields, you do not need any code to "push" or "pull" the link fields from the main form. I would look for that kind of code first.