menu bar - how to change in form

[leahf via AccessMonster.com]

There is a form (with a customized toolbar) with a subform to get details of
families. The toolbar is defined such that the delete button is not active
in this form.

However, when I double-click on the subform to get the record of a specific
family (where delete is allowed), and then return to the main form, the
delete button on the toolbar is active.

I have tried to define in the VBA form_activate Me.AllowDeletions = False,
but that doesn't seem to work. The delete button is still active.

Any suggestions?

Thanks.
Leah

 

[leahf via AccessMonster.com]

Is there anyone out there who can help me on this? I really prefer not to
have the user able to delete from the toolbar delete icon since it is too
easy to delete one or more rows without any checks on what is being deleted.

Thanks.
Leah