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
 
Go to Relationships and setup the apropriate keys and select cascade delete.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting records from a subform 2
Need combo box to refresh when moving to new record 2017 1
delete button deletes the wrong thing 2
Deleting a Form & SubForm Record 1
How programmatically Delete all records in a subform 4
#Deleted 1
Locked Subform still lets me delete a record 2
Inconsistent Add Record Performance 1

Back
Top