continuions form can not edit it

[Simon]

I have a form that is a continuions form based on a query, however i
can not edit any of the recored, what setting would need to be changed

 

[CompGeek78]

I have a form that is a continuions form based on a query, however i
can not edit any of the recored, what setting would need to be changed

Data is usually editable if the recordsource
- is based on only one table
- is based on two tables with a one-to-one relationship between them.

There are several reasons data may not be editable. Most often it is
due to the recordsource containing data from more than one table in a
one-to-many relationship. To get around the issue with one-to-many
relationships, you can set the RecordsetType property of the form is
set to Dynaset (Inconsistent Updates)

There are lots of other conditions which can cause a record not to be
editable, if you give us more information on your data setup, we can
probably give you a better idea of the problem.

Keven Denen

 

[Tom Wickerath]

Hi Simon,

As Kevin indicates, make sure that the query is editable. See the following list
of reasons that can make a query read-only:

Why is my query read-only?
http://allenbrowne.com/ser-61.html


Also, ensure that the form's Allow Edits property is set to Yes, and that the
form's Recordset Type is set to Dynaset.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath
__________________________________________________

I have a form that is a continuions form based on a query, however i
can not edit any of the recored, what setting would need to be changed

Data is usually editable if the recordsource
- is based on only one table
- is based on two tables with a one-to-one relationship between them.

There are several reasons data may not be editable. Most often it is
due to the recordsource containing data from more than one table in a
one-to-many relationship. To get around the issue with one-to-many
relationships, you can set the RecordsetType property of the form is
set to Dynaset (Inconsistent Updates)

There are lots of other conditions which can cause a record not to be
editable, if you give us more information on your data setup, we can
probably give you a better idea of the problem.

Keven Denen

 

[David W. Fenton]

m:

Most often it is
due to the recordsource containing data from more than one table
in a one-to-many relationship. To get around the issue with
one-to-many relationships, you can set the RecordsetType property
of the form is set to Dynaset (Inconsistent Updates)

Eh? Why not just try the Jet-only DISTINCTROW predicate? That is
going to do the job much more often than setting the type of the
form's recordset.

 

[David W. Fenton]

m:

I have a form that is a continuions form based on a query, however
i can not edit any of the recored, what setting would need to be
changed

I believe that the vast majority of continuous forms ought *not* be
editable. The only exception I make to this is with things like
invoice detail items on an invoice form.

Instead of editable continuous forms, I use a non-editable
continuous form and a linked subform that displays the detail record
of the row currently selected in the non-editable continuous form.

 

[???]

don't know what did you say