I have a subform linked to one mainform
The row source of the subform is base on a table.
The row source of the mainform is base on a query(should be read only query) because sum(), group by clause, join are used in the query.
The common identifier between the table and the query is an ID
Therefore, the link master link fields is ID and link child fields is ID.
The subform is in datasheet view.
I am able to insert new record in the subform, however, I can’t delete the record in the subform. When I insert the new record in the subform, the record was inserted into the table.
I “right click” on each row, then select “Delete Record”. Although the record is “deleted”, the record was still there when I reopened the form. I also checked the table to confirm the record was still in the table. I also tried the Delete key, but the records also can’t be deleted.
Sometimes, the “Delete Record” is greyed out when I “right click” on each row. And sometimes, it is not greyed out.
If I run the subform alone, the record in the subform can be deleted. The record was removed from the table when I checked the table.
May I know what could be the reasons why can’t I delete the record even though I can insert a new record in the subform.
Thank You.
The row source of the subform is base on a table.
The row source of the mainform is base on a query(should be read only query) because sum(), group by clause, join are used in the query.
The common identifier between the table and the query is an ID
Therefore, the link master link fields is ID and link child fields is ID.
The subform is in datasheet view.
I am able to insert new record in the subform, however, I can’t delete the record in the subform. When I insert the new record in the subform, the record was inserted into the table.
I “right click” on each row, then select “Delete Record”. Although the record is “deleted”, the record was still there when I reopened the form. I also checked the table to confirm the record was still in the table. I also tried the Delete key, but the records also can’t be deleted.
Sometimes, the “Delete Record” is greyed out when I “right click” on each row. And sometimes, it is not greyed out.
If I run the subform alone, the record in the subform can be deleted. The record was removed from the table when I checked the table.
May I know what could be the reasons why can’t I delete the record even though I can insert a new record in the subform.
Thank You.
Last edited: