edit a read only access form

[libbythomas]

I created an Access 2000 form from a query. But I cannot edit it. I can
flip through the records. If I create a table from the query
(maketable) and then create the form from the table, it is editable.
But that is not the way I want it. Any suggestions?

[Allen Browne]

Make sure the form's AllowEdits property is set to Yes.

If the form is based on a query, open the query itself, and see if you can
edit there. You won't be able to get the form editing if its source query
won't.

Examples of things that will make your query read-only:
.. 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.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<li*********@li bertyresources. org> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .

I created an Access 2000 form from a query. But I cannot edit it. I can
flip through the records. If I create a table from the query
(maketable) and then create the form from the table, it is editable.
But that is not the way I want it. Any suggestions?