Some queries are not updateable.
See Access help:
Query + Troubleshoot queries +  Select Query + I can't update data
from a query + Data can't be updated

It depends on what you have put into the query grid. Editable queries from
more than 1 table are the most common sort.

If, for instance, you have a Totals or a Crosstab query, then it can't be
edited.

Another typical scenario is when you have say a table of invoices with the
primary key of ItemID and a table of ItemsOnInvoices which has ItemID has
the Foreign key field.

You may try adding ItemID from the Invoices table (the 'one' table) whereas
you should have added ItemID from the ItemsOnInvoices table (the 'many'
table)

If your tables are not linked, then the query probably won't be editable.
For a list of what goes wrong, look on Allen Browne's pages.
http://allenbrowne.com/ser-61.html

The words in Bold Capitals refer to Sql words. To see these, open your query
in Design View. Click the down arrow next to the View button and choose SQL
View

If none of it makes sense. Past the Sql from your query in your next
message.

Evi

Thanks for the info guys