I have a form which I want to use to update data as needed. I keep receiving the notice that the recordset is not updateable. While trying to figure out why I came across this
Now unless I am reading this wrong, this says I can make changes to the data on the "many" side without any issues. And before I get asked I have the cascade update checked and my tables are fine. Thing is I have one form that works and when trying to model the other forms from it, they do not work.
You can edit bound controls based on a single table or tables with a one-to-one relationship. For controls bound to fields based on tables with a one-to-many relationship, you can't edit data from the join field on the "one" side of the relationship unless cascade update is enabled between the tables.
Now unless I am reading this wrong, this says I can make changes to the data on the "many" side without any issues. And before I get asked I have the cascade update checked and my tables are fine. Thing is I have one form that works and when trying to model the other forms from it, they do not work.