Field Cannot be updated!

[Ben Schminke]

I have seen this "field cannot be updated" error on several FAQ's, and
but none of the solutions seem to match my situation. I have a form
based on a query. When I try to add a new record, this error comes up
(twice). After I "OK" it (twice) I can add my record. However, If I
add the new records directly to the queries Dynaset there are no
problems or errors. I have 2 subforms on the form, but the problem
persists when I delete them. Likewise, I have some calculated fields
on the form (sub-total, grand total, etc..) but the problem persists
when those are deleted as well. Both of the fields that cause the
problem are comboboxes, but the problem persists when I convert them
back to Text Boxes. Help me Obi Wan Kanobi, you are my only hope.

Ben Schminke

[Allen Browne]

Ben, you have done some good trouble shooting here.

The next step might be to create a new form using the same query as your
main form does. Leave out the subforms and calculated controls; include just
the 2 combos, and any required fields. Does this form have the same problem?
Since you are able to add records directly to the query, this should work.

Now begin adding things from the existing form, testing until you hit the
problem.

If the new form does fail immediately, you could begin looking at the query
statement to see where these two fields come from (related table? Lookup
table?) and consider alternatives. Or, if the query/table actually displays
the combo boxes, you might consider opening the table in design view, and
changing the DisplayControl property to Text Box so you can really see
what's going on.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Ben Schminke" <ea*******@frontiernet.net> wrote in message
news:cd**************************@posting.google.c om...

I have seen this "field cannot be updated" error on several FAQ's, and
but none of the solutions seem to match my situation. I have a form
based on a query. When I try to add a new record, this error comes up
(twice). After I "OK" it (twice) I can add my record. However, If I
add the new records directly to the queries Dynaset there are no
problems or errors. I have 2 subforms on the form, but the problem
persists when I delete them. Likewise, I have some calculated fields
on the form (sub-total, grand total, etc..) but the problem persists
when those are deleted as well. Both of the fields that cause the
problem are comboboxes, but the problem persists when I convert them
back to Text Boxes. Help me Obi Wan Kanobi, you are my only hope.

Ben Schminke

[Pieter Linden]

Post your code/query SQL, young Jedi! If your field is a summary,
then you can't update it... is that calculated field bound to a
text/numeric field?

[Mapzoid]

< "field cannot be updated"

I recently had the same error with a fom. The form's recordsource is a query
that contains several caluculated fields. The form ran until I added a format
for either date or currency field in the query. Then I got the "field cannot
be updated"
error. As you pointed out, the query still ran. Changing the query did not
help.
Finally, I deleted and recreated the query and all is well. I don't recall if
I added
the formatting back to the query or put in in the form.

Steve Mappen