Deleting a Query

[Anne]

How do I delete a query in a module?

 

[Dan Artuso]

Hi,
If you mean how do you delete a query from code:
CurrentDb.QueryDefs.Delete("yourQuery")

HTH
Dan Artuso, MVP

 

[Gerald Stanley]

Currentdb.QueryDefs.Delete "queryName"

Hope This Helps
Gerald Stanley MCSD

 

[Anne]

Many thanks to you both.

 

[Chris Nebinger]

Another way:

docmd.DeleteObject acQuery,"QueryName"

Chris Nebinger