Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

allow additions with subform

I created a form which has "Allow additions" set to true, to only allow new records to be added. The form has three subforms. Adding new data to the "main part" of the form works fine, until I enter one of the subforms. Then the main form "locks" for further editing, only entering data in the subforms is possible.

I believe it is caused by creation of the record in the database for main part of the form, which is needed to bind the primary keys of the subforms in the database. This probably sets the flag that record on the form is not anymore "new".

I believe the user should still be able to edit main part of the form after adding records in related subforms. Is there a way to achieve this?

allow additions with subform

I created a form which has "Allow additions" set to true, to only allow new records to be added. The form has three subforms. Adding new data to the "main part" of the form works fine, until I enter one of the subforms. Then the main form "locks" for further editing, only entering data in the subforms is possible.

I believe it is caused by creation of the record in the database for main part of the form, which is needed to bind the primary keys of the subforms in the database. This probably sets the flag that record on the form is not anymore "new".

I believe the user should still be able to edit main part of the form after adding records in related subforms. Is there a way to achieve this?this (I am proficient in LO Basic)?

allow additions with subform

I created a form which has "Allow additionsnew data" set to true, to only allow new records to be added. The form has three subforms. Adding new data to the "main part" of the form works fine, until I enter one of the subforms. Then the main form "locks" for further editing, only entering data in the subforms is possible.

I believe it is caused by creation of the record in the database for main part of the form, which is needed to bind the primary keys of the subforms in the database. This probably sets the flag that record on the form is not anymore "new".

I believe the user should still be able to edit main part of the form after adding records in related subforms. Is there a way to achieve this (I am proficient in LO Basic)?