If it is not a security violation for you, it would be very helpful if you could zip up your db and attach it to a post. Do a Compact and repair first. You should remove any sensitive data as needed.
I made some changes. Instead of having the button to open the form, I just created it as a another subform on a tab control. But my problem of not being able to add a new record is still happening.
I have previously had problems with attaching the database to a post so I uploaded it to dropbox.
https://www.dropbox.com/s/6yunrjz1j3...abase.zip?dl=0
Thank You!
I have fixed the problem! Thank you!
Your form "frmMaintContInfo" record source should only have the table "tblMaintContract" in it (NOT tblCustomers). Add the FK field for Customers and set the sub form control "Link Master"/"Link Child" fields.
IMO, You really ought to fix the field names in the tables. See the field names in Post#29...
Edit... seems you solved the problem as I was posting.
Good luck with your project.............
What is the problem with my field names?