Fields not editable when form based on a complex query

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?
 
J

JP

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.
 

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

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Query-based form with blank fields 1
Adding fields from a different query 6
Form based on query with option group 4
Access Form - Lock Fields from Editing 0
Tab controls not writing to table 2
Fill in form using query 2
filtering a form based on a filter on an open form 2

Top