i want to run a delete query on my forms close event procedure. i have the following code:
(code)
dim db as database
set db ~ currentdb
docmd.set warnings false
db.execute "queryname", dbfailonerror
setdb ~ nothing
docmd.setwarnings true
(/code)
this debugs with no problems, but when i close the database it doesnt delete the blank entries? i have also tried the same code on my formload() event and had the same results?