"field cannot be updated"

[Guest]

I have a form with a subform and I keep getting this error.

I have a combo box in the main form that i select a value from. My subform
then show the related data. When I try to create a new record by entering
information in the subform i get this error saying "field cannot be updated".


I've looked at other posts but they had expressions in their query. Mine
does not.

any suggestions?

Thanks

 

[John W. Vinson]

I have a form with a subform and I keep getting this error.

I have a combo box in the main form that i select a value from. My subform
then show the related data. When I try to create a new record by entering
information in the subform i get this error saying "field cannot be updated".


I've looked at other posts but they had expressions in their query. Mine
does not.

You can't update expression fields in a query, obviously - but there are some
queries that you can't update at all, and others which may need tweaking to be
updateable. If the query underlying the form is not updateable, then neither
is the form!

Could you post the subform's Recordsource? If it's a Query, please post the
SQL view.

John W. Vinson [MVP]