Ensuring Child is deleted along with Parent

[=TB=]

Is there away of ensuring that when a record on a form is deleted any child in a relationship with it on a sub form is deleted?

Thanks in advance

 

[dcx693]

You could use some VBA code to do it, but really the best way to handle relationships like these is using Access' cascading relationships that you set up in the Relationships window. You can set it up so that if you delete a record on the "one" side of a one-to-many join, the child records on the "many" side get deleted as well. Check out the Access on-line help and write back if you need more assistance.

 

[=TB=]

Thankyou

Force Referencial Integerity / Cascade Delet Related Records is not an option I can use in this perticular instance. Would you happen to know what the vb code would be to do this?

Thanks in Advance.