Subform Allow Edits Issues ?

[edisonl via AccessMonster.com]

Hi,

I have a form contains x numner of subform (Eg: x=10)
-The funny thing is ALL 2nd to 10th subform is editable, add new record)
-First subform is unable to.

Has check properties
AllowEdits=yes,
Record Locked=Edited Records

All properties for above (AllowEdits, Record Locked are Similar), but only
subform 1 is problematic (cannot edit or add records)

Also has programatically set>>
subform1.setfocus
subform1.form.allowedits= true

 

[Klatuu]

It is likely you have created a recordset as the record source of those
subforms that is not editable. You can tell if a recordset is editiable by
opening it in datasheet view. If the add record icon is greyed out, the
recordset can't be edited.

 

[edisonl via AccessMonster.com]

Hi Klatuu,

hanks for replying.. How do I re set it to editable ?


~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~ ~ ~ ~ ~

It is likely you have created a recordset as the record source of those
subforms that is not editable. You can tell if a recordset is editiable by
opening it in datasheet view. If the add record icon is greyed out, the
recordset can't be edited.

Hi,

[quoted text clipped - 12 lines]

subform1.setfocus
subform1.form.allowedits= true

 

[Klatuu]

It is not a matter of making a recordset editiable by setting anything. It
becomes not editable by how it is constructed. For example, no Group By
recordset can be edited. The reason a recordset can't be edited is because
the query can't determine exactly which record to update. You have to redo
your query so that it can be editied.
--
Dave Hargis, Microsoft Access MVP

Hi Klatuu,

hanks for replying.. How do I re set it to editable ?


~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~ ~ ~ ~ ~

It is likely you have created a recordset as the record source of those
subforms that is not editable. You can tell if a recordset is editiable by
opening it in datasheet view. If the add record icon is greyed out, the
recordset can't be edited.

Hi,

[quoted text clipped - 12 lines]

subform1.setfocus
subform1.form.allowedits= true

 

[John W. Vinson]

Hi Klatuu,

hanks for replying.. How do I re set it to editable ?

By correcting the error in it.

If you would like help doing so, please open the query in design view. Select
View... SQL, and copy and paste the SQL text to a message here. There are many
reasons that a query might not be editable; e.g. no Totals query is ever
editable, a UNIQUE VALUES query or a UNION query won't be, a two-table query
will only be editable if there is a unique index such as a Primary Key on the
joining field, etc. etc.

 

[edisonl via AccessMonster.com]

Dear Vinson, Klatuu:

Culprit is the GROUP BY clause... has remove it now it works like a clock..
Thanks for both (Vinson, Klatuu) for your help.

Regards & God Bless, Edison