Field cannot be updated

Question

I have an Access 2007 database for apprenticeships. I have a learner details table, courses table and units completed table.  The tables are all linked together. When I try to add units completed on a form I get the message "unable to update field". Can anyone tell me why this is happening and how to solve it? Although this message appears, the units are added to the table.

Answer 1

Hi Jeanette,

the problem may be that your form is trying to update 2 tables at once! 

You may need to lock at the forms Record Source and determine if there is more than one table with data being inserted too...

---

Brian, ProcessIT- Hawke`s Bay, New Zealand

Answer 2

>>>When I try to add units completed on a form I get the message "unable to update field". Can anyone tell me why this is happening and how to solve it? Although this message appears, the units are added to the table.

According to your description, could you use Sql sentence to add unit record? I suggest that you could provide more information about this issue, for example table structure, screenshot etc., it will help us reproduce and resolve this issue.

Thanks for your understanding.