Problem? Can n e one suggest a solution

[Confused_Case]

Ave created forms etc from tables, within a sub form i am trying to enter data but its giving me the following error when i try to enter data into the role no, field. "Field cannot be updated"

Then if i go to the next field in the subform and try to enter data its coming up with the following error,

"Cannot add record(s); join key of table 'AC_ROLE' not in recordset"

Can any one suggest possible solutions!

 

[The_Doc_Man]

Somehow you have spelled a field name or table name incorrectly in your JOIN, thus making it impossible for Access to locate the field to be updated through that query. If Access can't find it (or identify it), it can't update it. Hence the errors you are seeing.