I'm using Access 2016. I've created an application with a form and subform. The main form has a control which filters the records showing in the subform. The record source of the subform is a query consisting of several tables between which are left and right joins. Because of this, the Recordset Type property of the subform has been set to Dynaset (Inconsistent Updates) to allow users to edit data in the subform.
For some reason, a new record is added to the base table when the field bound to a column in the query derived from that base table is edited. The field in the subform has been set to combo boxes instead of text boxes to control data entry. For instance, if I change a value in the Topic field of a subform record, a new record is added to the Docs table with the value entered in the Topic field but blank for every other field.
I'd appreciate it if someone could tell me why this is happening and how I can prevent it.