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 just can't click to enter a new record (and no '*' is visible signifying that you can enter a new record). One my other form for editing existing records, the subforms work fine.
I have searched around and tried a few things and verified the following:
--If I open the tables that the subform is using, I can enter records so it isn't permission related.
--SQL tables have auto-incrementing identity fields with primary key constraints added.
--The subform has allow additions set to true
I am guessing that is has to do with the record id not being entered in the SQL server table yet when adding a new record so the subform is unable to link to the main form, however I have not been able to find a resolution for this.
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 just can't click to enter a new record (and no '*' is visible signifying that you can enter a new record). One my other form for editing existing records, the subforms work fine.
I have searched around and tried a few things and verified the following:
--If I open the tables that the subform is using, I can enter records so it isn't permission related.
--SQL tables have auto-incrementing identity fields with primary key constraints added.
--The subform has allow additions set to true
I am guessing that is has to do with the record id not being entered in the SQL server table yet when adding a new record so the subform is unable to link to the main form, however I have not been able to find a resolution for this.