Access Question - Form based on Query that will not accept changes

[gheyman]

I have a for that is based on a Query. I can make changes to the for fields and the table adjusts accordingly. Just as I want. But then I added a new table (second) to the query and linked the common field (joined). I added a new field to the query for the new table. When I run the query I get the right results. But when I go back to my form and try to change any of the data, it will not allow me to. Its like all the fields in the form a locked. The data is there, the records change as expected, but I cannot change the data any longer.

Any idea what I did wrong or how to fix it?

Thanks

 

[welshgasman]

See if any of these apply

http://allenbrowne.com/ser-61.html

HTH

 

[bobsan42]

The query provides you with a set of data called a recordset.
These can be editable and not editable - you ended up with the second one.

3 ways to solve this:
1. simplify the query - see which connection or field makes it not editable and remove it from the query if it's presence is not crucial
2. Make the form unbound - fill in the data by code, and then put the changes back in the tables by code (not always possible - only for simple forms - one record at a time)
3. use a temporary / intermediate table to put data in and then take it back - requires additional coding too.