Where is the OnDelete Event ? 1

[Dagon]

I haven't used Access in about 5 years but I rather stupidly volunteered to fix a bug in a form. There is a master detail form and I want to amend it so that, if a parent record is deleted, it removes all the child records.

I thought I would be able to do this by amending the "on delete" property of the master form. The problem is I'm so rusty with Access I can't even remember how to find the "on delete" property. I've tried clicking on properties everywhere in the form and can't find it. If I click on a field, for example, I get field level events. If I click on the form background, I get form level events. But how do I get record level events ? It's a very old version of Access - Access 97.

 

[ssatech]

Right-click your form and go to design view, properties, Event, On Delete

 

[Remou]

You may wish to look ay setting cascade delete in the relationships window. You can usually get the form properties by double-clicking the little square directly under the title in the top left-hand corner.

 

[Dagon]

But where do I need to click in the form before I view the properties ? For example, if I click somewhere in the detail section, all I get for properties->event is:

On Click
On DblClick
On MouseDown
On MouseMove
On MouseUp

 

[Remou]

Have our posts crossed in the mail?

 

[Dagon]

Remou, my response was to ssatech.

 

[Dagon]

Yes, I've found that now. Thanks for your help.