Deleting Records from a Continuous subform

[stanger1]

I am trying to set up a continuous subform that has the ability to delete individual records. The main form is based on a table, but the subform is based on a query of two tables. I want to be able to place a delete button next to the row of the continuous subform and delete the record based on the query. Is there a way to do this? I have tried to create a delete query, but have not had any luck. Any help would be greatly appreciated.

 

[neileg]

If you have enforced referential integrity, you should create a delete query to delete the primary record and the secondary record will also be deleted.

If this is not the case, or not appropriate, you will need to use two delete queries, one for each table.

 

[stanger1]

Neil,

Thanks for the reply. I need to delete only individual records on the continuous subforms. I will try to use the delete query idea.