Don't know if this helps but this is the query I am trying to run
DELETE tblMissile.MissileID, tblMissile.MissielTypeID, tblMissile.MLocationID, tblMissile.StatusID, tblMissile.MissileNum, tblMissile.Pri, tblMissile.EngDate, tblMissile.INEDate, tblMissile.DiscA, tblMissile.DiscB, tblMissile.DiscC, tblMissile.MNote
FROM tblMissile
WHERE (((tblMissile.MissileID)=forms!qryMType![qryMissileInfo Subform]));
It works fine when I run just the query but when I run the query from a button on the form it does not work.