Re: Queries Dont Allow Edits

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:SkJ6h.6213$IR4.3416@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
FIECA wrote:
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.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.

Relevant Pages

  • Allowing Edits in Form
    ... A query is supplying the data to the form. ... >>The form opens, but does not allow edits. ...
    (microsoft.public.access.forms)
  • Re: Theoretical question
    ... we usually use a query that has fields from ... The difference is that a report is only reading the data and not trying to ... make edits or insertions. ... It is easier to include multiple tables if you are only ...
    (microsoft.public.access.forms)
  • Re: Continuous Forms Footer
    ... The only things I'm allowing on the continuous form are filters and edits. ... > If the query is updatable, and the form's AllowAdditions property is set ... based on criteria selected in the main form. ... The footer has controls that display totals for the records ...
    (microsoft.public.access.forms)
  • Re: No lines at all in Query results
    ... > Heads when the Qurey runs, and my computer displays the Column Heads and a ... allow edits then the blank row would not be there. ... Now, if this were a form datasheet then you can set them to allow additions, but ... A query does not have this capability AFAIK and if that is what you ...
    (microsoft.public.access.queries)
  • Re: Bound Form will only update 1st record
    ... and data type mismatch error. ... The code I've been using has worked for me in the past with two combo boxes. ... After a selection is made in the 1st combo box, a query is ... >>what record I'm on when I make the edits, the edits are always saved to the ...
    (microsoft.public.access.formscoding)