If you set the relationships of the main table to the 6 related tables to "Cascade deleted records" Access will do this automatically when you delete the main record.
This is NOT a recommended answer, simply an answer to the question. Allowing that property can cause havoc if a user is not careful what they are deleting. Imagine someone deleting your biggest customer from the db by accident. Along with deleting the customer would go their orders, payments, EVERYTHING related to them.
A more safe way to do it is to run SQL statements to delete the related records before deleting the main record with a DoCmd.RunSQL statement like this:
DoCmd.SetWarnings False 'Turn off confirmation message
DoCmd.RunSQL "Delete from MyTable Where ID = "XyZ"
DoCmd.SetWarnings True 'Turn on confirmation message
HTH
Joe Miller
joe.miller@flotech.net