Form won't accept data

  • Thread starter Thread starter Gibson
  • Start date Start date
G

Gibson

I have a form whose control source is a query. When I try to add a new
record on the form none of the data fields will accept data. I can't type
data into the field. I went to the query itself and ran it then created a
new record in the query with the same result. I could not type any data into
the new record. I'm kind of new to this. Can anybody give some direction on
what to look at that may be causing this problem?
 
The solution may be as simple as removing some of the tables to make the
query simpler.

If that doesn't work, 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's Recordset Type property is set to Snapshot.
.. 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.)
 
Back
Top