Field Cannot Be Updated error

[MarcieFess]

I'm getting a "Field Cannot Be Updated" error when trying to add a record to a sub-form. I click "ok" and continue...I can input the first field in the sub-form, but nothing else. I can go backwards to the previous record, then when I come back to that record, the data that I input is there and I am now able to complete the rest of the information.

While we're at it, I'd like to be able to make sure that a new Store is not created at this point in the form; I only want them to use an existing Store.

Marcie Fessler,
Access 2010

 

[Pat Hartman]

Check the query. You may be selecting the PK field rather than the FK field. That allows you to create records in the 1-side table but your sub-form is probably intended to create records in the many-side table.

Open the query and try to enter a record directly. You may see what is causing the problem. If the PK/FK selection is correct, the "lookup" fields will automatically populate when you enter the FK value.