Hi Sarah,
>delete from chatyear where chattelsid = thisform.keyvalue
>
>This works in my .app but doesn't do the delete in my .exe
This should be working in the .EXE as well. The only area I would look at would be TABLEUPDATE. Is it possible that you come out of a form without saving and you issue TABLEREVERT so the data is not updated.
I think you are in the right direction. Try issuing a TBALEUPDATE right after the delete SQL. This way you will be able to find out wether it is the problem of exe file or not. Then look at other areas where it could from....