I have searched for an entire day now but I cannot find a solution to this MS Data Project issue:
I have a subform in datasheet view whose RecordSource is a SQL statement with one SQL table. The only field the end users really use is one combo box. The SQL table has one primary key (ID) (int, identity = N). When the user changes the value of the combo box, everything looks good except when they navigate to a new record, they rec a cryptic msg about not saving the record due to underlying recordsource. My research indicates a problem with the identity setting on the PK field.
So Far - I removed the Identity setting from Y to N in the PK Field but I still get the same error. When I remove the PK setting altogether I rec a different error stating that "Recordset is not updatable". In my reserach, I would say that updating a SQL table from a MSAccess Form requires a PK field - So I changed it back as a PK.
This ID field is not critical as no new records are created nor are they deleted. All I need the end users to do is change the value on this one combo box.
Any Ideas? Thx in advance
I have a subform in datasheet view whose RecordSource is a SQL statement with one SQL table. The only field the end users really use is one combo box. The SQL table has one primary key (ID) (int, identity = N). When the user changes the value of the combo box, everything looks good except when they navigate to a new record, they rec a cryptic msg about not saving the record due to underlying recordsource. My research indicates a problem with the identity setting on the PK field.
So Far - I removed the Identity setting from Y to N in the PK Field but I still get the same error. When I remove the PK setting altogether I rec a different error stating that "Recordset is not updatable". In my reserach, I would say that updating a SQL table from a MSAccess Form requires a PK field - So I changed it back as a PK.
This ID field is not critical as no new records are created nor are they deleted. All I need the end users to do is change the value on this one combo box.
Any Ideas? Thx in advance
