Forum Discussion
Ms Access cannot edit the data in a query with two table source
Hi, Can anybody help me what to do on my Access form. My form data source is a query with two tables. Initially, I can edit my data in a form with 1 table source but when I added another table w...
There are circumstances where results of a query cannot be edited, typically because Access doesn't know which row is being edited. This may be informative - but when it says "three or more tables" that is misleading because it is possible to design a query on one table that cannot be edited: https://support.microsoft.com/en-us/office/edit-data-in-a-query-6ca3edfc-6d66-4d90-8219-c2b258d5bed7