"field cannot be updated"

J

Jose

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
 
J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top