|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 6th, 2007, 05:36 PM
posted to microsoft.public.access.forms
|
|||
|
|||
"field cannot be updated"
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 -- JLV 
|
|
#2
August 6th, 2007, 11:45 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
"field cannot be updated"
On Mon, 6 Aug 2007 09:36:08 -0700, Jose
wrote: 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]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
