I have a subform within a subform.
The main subform is linked to the second subform by CostReducProjtD
The second subform has multiple records with the CostReducProjtID repeating for each record.
What I want to be able to do is to be able to delete all the records in the second subform that match the
CostReducProjID in the Main subform.
When I run the query below it asks for a value to be entered yet both forms have the CostReducProjtID showing.
Is the query correct the way I have it or is there a different way to do this?
DELETE CostReducProjDetailsTbl.*, CostReducProjDetailsTbl.CostReducProjtID