deleting 2

[EscapeUK]

How do I in code

delete a query called qry1
delete another query called qry2
delete yet another query called qry3

However is is possible that they might not exist.

so what i need to do is search for the qry if it exists delete it if not do nothing

ta

 

[Rohdem]

Check out this FAQ to see if an object exists:

faq181-36

to delete an object, use

DoCmd.DeleteObject acQuery, "queryname" Mike Rohde
rohdem@marshallengines.com

 

[Quehay]

Thanks Rohdem--you may have answered a question I just posted above.

Jeff