subform - delete/edit options?

[short]

I have a form with about nine subforms with links to tables on each. (This
was the way it was designed) I need to be able to delete/edit items in each
table/subform. I was just wondering what is the best way to do this?
Is it easier to create a delete form where the user can delete and edit
each. Or have buttons on the the main form with delete and edit?

thanks,

 

[John W. Vinson/MVP]

I have a form with about nine subforms with links to tables on each. (This
was the way it was designed) I need to be able to delete/edit items in each
table/subform. I was just wondering what is the best way to do this?
Is it easier to create a delete form where the user can delete and edit
each. Or have buttons on the the main form with delete and edit?

thanks,

If your current form is not editable - perhaps it's set to be not
editable, or perhaps the forms are based on queries which aren't
editable. By default, Forms allow editing and deleting natively.
Unless you specifically disable the capability, you can delete records
on subforms directly - select a record and choose Records... Delete,
or if the subform's select bar on the left of the screen is active,
click it and press the Delete key.

Creating a separate form would really be overkill. Buttons would make
the option more visible to the user and should be easy to implement.

 

[short]

Where on the subform are you able to disable the ability to delete/edit items
in a subform?

 

[John W. Vinson/MVP]

Where on the subform are you able to disable the ability to delete/edit items
in a subform?

View the Form properties (of the form you're using as a subform); you
can independently set the Allow Edits, Allow Deletions and Allow
Additions properties.