Command Button to DELETE from 2 tables

[bt_user]

Hi,

I am sure this is super easy to most people, so be patient with me.

I have a form that references 2 tables (form within a form). The main form references the Contact Info of an employee (tblContact_Info). The subform references which team or teams this employee is on (tblLookup_UserTeam). All the records are tied together by the UserID. tblContact_Info will only have 1 entry with the UserID. tblLookup_UserTeam could have one or multiple records with the UserID.

I would like to put a command button on the main form to "Delete Record". So if an employee is no longer needed in the database, I could click this button and Delete the Employee's Contact Info from tblContact_Info, as well as any and all records associated with that employee's UserID in tblLookup_UserTeam.

What code would I need to associate with this command button?

THANK YOU!!!!

 

[bat17]

If you set up the relationships in the relationship window you can tell access to encorce referential relationships. If you then select to "Cascade Delete Related Records" Access will automaticaly delete all of the child records when you delete the parent record.

HTH

Peter