strange behaviour in coldfusion - can anyone shed light

I am using Coldfusion MX code to update some MS Access database tables.

I have written some code which checks to see if a record exists in a table and if it does then it deletes it.

What is happening is that the check confirms that the record exists but I then get an error message telling me that the record has been deleted when I try to delete it.

I have attached the code I use and a screenshot of the results.

Can anyone explain to me what is happening and how I can fix it.

<cfoutput>Status = 0<br></cfoutput>


<cfoutput>Unit=All <br></cfoutput>

<cfquery name="getexistingsubidrecord" datasource="#MM_datasource#">
            SELECT * FROM SubmitAssessorAcceptance WHERE Subid=#thesub#;
</cfquery>

            
<cfif #getexistingsubidrecord.recordcount# GT 0>
            
<cfdump var="#getexistingsubidrecord#">
            
<cfoutput>Record already exists</cfoutput>
                  
<cfquery datasource="#MM_datasource#">
                  DELETE SubmitAssessorAcceptance.* FROM SubmitAssessorAcceptance
                  WHERE Subid=#thesub#
</cfquery>

</cfif>
            
<cfoutput>Delete all</cfoutput>

Thanks
scr1.JPG