in a form, I can't alter data pulled from a query

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi All,

I have a subform made from a query.

The problem is, the data shown in the form is locked. How can I alter
the data? If I pull the data from a table, I can alter it.

I can't mess with the tables and the form requires info from various
tables (the query provides it all).

Any way to alter data in a form pulled from a query?

Thanks for any advice

Jeff
 
Open the query. Can you edit the data there?

The query results will be read-only if any of the following apply:
.. It has a GROUP BY clause (totals query).
.. It has a TRANSFORM clause (crosstab query).
.. It contains a DISTINCT predicate.
.. It uses First(), Sum(), Max(), Count(), etc. in the SELECT clause
(performs aggregation).
.. It involves a UNION.
.. It has a subquery in the SELECT clause.
.. It uses JOINs of different directions on multiple tables in the FROM
clause.
.. The query is based on another query that is read-only (stacked query.)
.. Your permissions are read-only (Access security.)
.. The database is opened read-only, or the file attributes are read-only, or
the database is on read-only media (e.g. CD-ROM, network drive without write
privileges.)

If the query is editable but the form is not, check the form's AllowEdits
property.
 
Thanks Allen,

It's based on a complicated query! complicated for me, anyway.

I've created a new form for editing the information that draws directly
from the origin tables. A little more clicking of buttons, but gets the
job done.

Thanks for your reply,

Jeff
 
Back
Top