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