Record delete option

  • Thread starter Thread starter Darrin
  • Start date Start date
D

Darrin

I have one main form with 4 sub forms attached to it that
are all linked to add a record when you input a new SSN.
The problem I am having is when trying to delete a record;
I put a delete record button on the form but it will only
work on the main form. What or how do I need to write this
to be able to clear/delete the corresponding records in
other tables at the same time?
 
Sounds like you need to run a delete query that deletes the parent record
whenever one of the child records is deleted.

HTH
Sam
 
This will only delete child records when a parent record is deleted. It
seems this has already been done as the records are deleted via the main
form.

HTH
Sam
 
Back
Top