Field cannot be updated but it does

[NeilT123]

I have an input form which is a subform of a subform and when I try to add a new record I get a warning box saying "Field cannot be updated" but if I click the OK button (the options are OK and Help) the field is updated and a new record is created.

Does anyone know why this may be happening and is there anyway to stop the warning box?

 

[SeeThru]

Check the structure of the query the form is based on - it must be updateable.

Also, check the form design to see if the input bos is set to allow updates.

Also, check that you are not trying to set the value to a primary key field or an autonumber field. Autonumbers will always give this and should not normally be set or even seen on a form. Promary keys will normally give a more specific error if you try to add duplicates, but that may be it.