Queries Dont Allow Edits

[FIECA]

I created a form to display record details based on a table and then also
based on the results of a query I use to specify which records I want to
see. The problem is that whenever I open the form based on the query, when
the record is displayed I cannot then go back and edit the information in
the record. I even checked the form properties and made sure that edits,
additions, and deletions are allowed. Still no joy. Any way to change
whatever is wrong to let me edit the fields in a record after running a
query and displaying the results in a form. I have never encountered this
before. Is it a new feature?

Thanks,

Tom

 

[Rick Brandt]

I created a form to display record details based on a table and then
also based on the results of a query I use to specify which records I
want to see. The problem is that whenever I open the form based on
the query, when the record is displayed I cannot then go back and
edit the information in the record. I even checked the form
properties and made sure that edits, additions, and deletions are
allowed. Still no joy. Any way to change whatever is wrong to let
me edit the fields in a record after running a query and displaying
the results in a form. I have never encountered this before. Is it
a new feature?
Thanks,

Tom

Many queries don't allow edits of their result set. I suspect you have
inadvertantly created one of these. If you open the query by itself can you
edit the data? If not then you need to fix that.

 

[FIECA]

Rick,

That is the case. However, I don't know how to "fix" the query to allow
edits. This is my first time creating queries in Access 2002. I didn't
have this issue with older versions, so I am not sure how I created the
situation. If you could advise me on how to fix the query to allow the data
to be edited, that would be a great help.

Thanks again,

Tom

 

[Rick Brandt]

Rick,

That is the case. However, I don't know how to "fix" the query to
allow edits. This is my first time creating queries in Access 2002. I didn't
have this issue with older versions, so I am not sure how I
created the situation. If you could advise me on how to fix the
query to allow the data to be edited, that would be a great help.

There is a help file topic named "When can I update data in a query?" that you
need to look at. There are no easy (general) answers and the reason a query is
not editable is unique from one query to the next.

However...

A Query with View - Totals enabled is never editable.

A Query using the Unique Values option (DISTINCT SQL key word) is never
editable.

A Query with more than one input table or query is not editable unless it is
constructed "just right" and if you add too many inputs it is unlikely to ever
be editable.

A query based on an input that is not editable will never be editable.

A passthrough query is never editable.

(any of these strike a chord?)

 

[FIECA]

Rick,

Actually, my query pulls in some fields from other tables. Any tips on how
to, as you say, construct it just right? I built the query using the query
wizard and selected the input fields from their respective tables using the
wizard. As I said, I have done this type of thing in older versions of
Access and never run into this situation. I guess my main question is where
is the setting or whatever that controls this, so I can change it. I really
appreciate your help.

Thanks,

Tom