Cannot delete records in subform, but can creat new records in subform

[runner231]

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 based 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 the 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.

[Micron]

I have read that main form properties such as Allow Deletions = No, or a main form query property being Snapshot etc., can propagate to a sub form but have not experienced this. If you can delete from the subform when opened directly, the inference is that there is something about the main form that is the cause. If you're not getting an error message and have not turned off warnings in code, then the only suggestion I have would be to copy the forms and alter the main form copy so as to base it on an updatable query and see what happens. If that solves it, maybe your main form source could calculate those fields on the form instead of in the query. If you are getting an error message, it might help to know what it is.