Error "Field can not be updated" when entering data in a subform

[Patrick]

Can anyone give me a hint on the following:
I have a form, with a subform (datasheet)
Some default values are set by refering to fields in the master form.
Looking at the new record line, these default values are correctly visible.
When entering any field in the new record, I get the error message "Field
can not be updated". When I OK this message box, my entered value IS in the
newly created record.
Help on this tells me that eihter this record is locked by another user (is
not) or that I am trying to change a value of a locked control (no controls
locked)
Please advise...

 

[Crystal (strive4peace)]

Hi Patrick,

If you have form properties set to AllowEdits, then it
sounds to me like your subform may be using more than one
table in its RecordSource. It is best to base each form and
subform on only one table if you plan to change data.

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
have an awesome day
*

 

[Patrick]

Thanks Crystal,
The form uses a query as recordsource.
In this query I have added a calculated field. This was the field that
couldn't be updated on new record creation.
Moved the calculation up to the main form and this solves the issue.

Thanks again for pointing me in the right direction

 

[Crystal (strive4peace)]

great! you're welcome, Patrick happy to help

Warm Regards,
Crystal
remote programming and training
http://MSAccessGurus.com

free video tutorials
http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page book that covers essentials in Access

*
have an awesome day
*