The edit form was simply a copy of the new form with the properties changed to not being data entry and allowing edits. The only difference being is that I added a second subform (which works also) and some filters to search. That is why I was initially thinking the problem is that their is...
The form is bound.
Both the tables linked to the main form and subform have primary keys
Permissions on the table are good. When I am in my form I created to edit records, I can insert using that same subform when there is already an existing record.
All forms allow additions.
I have an access database that I recently converted over to use linked SQL Server tables.
I have a form that is used to create a new record that contains two sub-forms. This worked perfectly when using tables in Access but now I can not enter anything into the subforms. There is no error, I...