Cant Edit Forms Data ?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I have two forms with sub-forms on them and they were working.
The customers form shows via the sub-form the material used for each job for
that customer
the sub-from is linked via a master child relationship

It correctly shows the right data but i cant edit any data in it
it is not read only or any fields locked ???

What can i check or do?

P.S. the query that the sub-from is based on does the same, no editing the
data
 
If you open the MS Access help and type the key words "recordset read-only"
you will see the topic: When can I update data from a query?

This topic explain several conditions that enable/disable editings of
recordset.

Take care

Mauricio Silva - 2005
 
I have two forms with sub-forms on them and they were working.
The customers form shows via the sub-form the material used for each job for
that customer
the sub-from is linked via a master child relationship

It correctly shows the right data but i cant edit any data in it
it is not read only or any fields locked ???

What can i check or do?

P.S. the query that the sub-from is based on does the same, no editing the
data
Click to expand...

See the Help for "Updateable". Some queries can be updated; some
cannot. Typically with a Form/Subform arrangement the main form would
be based on the "one" side table, or a query based on the "one" side
table; and the subform on the "many" side table. It seems that you may
have based the subform on a multitable query (or perhaps a Totals
query or UNION query, which will never be updateable).

If you can't figure out why the query isn't updateable, please open it
in SQL view and post the SQL text here.

John W. Vinson[MVP]
 
Back
Top