Recordset not updatable from form

[WendyCha]

I have a form that worked fine until i added a field from a linked table. I have an append query, "Usage Query1" that finds the max data in a column and places it into a table called "Usage1". This table in linked to my main table called "Measure". I also have an append query called "Usage Query2" that finds the max data in a column and places it into a table called "Usage2". This is also linked to table "Measure". I added a field from Usage1 just fine with no error, but when i add a field from Usage2 i get "This recordset is not updatable" in the status bar when i open the form again. I can still update and add records in datasheet view however just not from the form. What is causing this? I need help ASAP!



Thanks for any help!!

[RuralGuy]

Perhaps something in this link will help: http://allenbrowne.com/ser-61.html

[WendyCha]

Thanks, I looked at that link before posting. I dont see how it can help me? The form worked just fine when i added the first field from the linked table, the second field is just like first field i added, nothing different but the actual data. It has same query structure and same datatypes.