In my current project, I have an imported table of Clients that I don't want to alter. Linked in a query, I also have two other tables; One holds addresses for the names, linked by Client Reference and the other holds additional comments, both of which need to be updateable.
This was working perfectly and I designed a form around it. However, I needed to add a field to the table that holds the additional comments. Since then, the form and even the query that it's based on is no longer editable. The field is a Yes/No and has a tickbox on the form. Can anyone suggest why just adding this field may stop the query from being editable?
This was working perfectly and I designed a form around it. However, I needed to add a field to the table that holds the additional comments. Since then, the form and even the query that it's based on is no longer editable. The field is a Yes/No and has a tickbox on the form. Can anyone suggest why just adding this field may stop the query from being editable?
Last edited: