Fields not editable when form based on a complex query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that is based on a rather complex query. The query which the
form is based on is the final query in a chain of several queries which pull
info from several tables and perform calculations. The form works properly,
but the fields are not editable. Nor can I edit the fields when I run the
query directly. Is this a limitation because the form fields are based on
such a query?
 
Yes.

There are rules for when the results of a query are updateable. Once you
get into one:many or many:many relationships, the results are often not
updateable since it doesn't want to update multiple records based on a
single entry in a query.

I believe that there is an explanation in the Access Help and there are
probably explanations in on-line resources (e.g, the MS Knowledgebase). Ask
one of the MVPs to point you to some good explanations.
 
Back
Top