Single delete button for multiple tables on form and subform

[jabrjo]

I would like to create a button that deletes records from both the form and the subform. I currently have two delete buttons on the from but it looks a little confusing. I'm assuming I would have to tweak the code behind the button but have no idea where to start. Any help would be greatly appreciated!



Thanks

[orange]

You delete records from tables. Typically a form/subform is set up when 2 tables have a 1 to many relationship.
In general, using a Person has Many Hobbies as 2 tables in a 1 to many relationship, if you want to delete the Person you
would delete the Person and their related Hobbies.

You can set up to do this by setting up Cascade Delete on the relationship.
You may want to do a little research on MS Access Cascade Delete.

However, many developers would suggest an approach where you never do physical deletes in databases.
You have a boolean (yes/No) field in your tables that is used to signal whether this record is "logically deleted".
If the field value is True, then the record is "deleted". The issue with this approach is that you have to respect the
field in all queries etc. The benefit is that you never lose a historical record.

[jabrjo]

Thanks Orange. I'll see what i cant find!