delete a query

[M8KWR]

is there a way to delete a query in code, i know how to drop a table, but was wondering if there is some code to delete a query

many thanks for any help in advance

 

[JerryKlmns]

DoCmd.DeleteObject acQuery, "YourQueryName

 

[mp9]

Alternatively you can use DROP is SQL, even though it is a query you want to drop - you can still use DROP TABLE YourQueryNameHere;

The advantage (I think)of using a DROP SQL statement over the DeleteObject is that you don't have to have the DB open exclusively to run it.