[AccessD] Modifying a query

Hi Rocky

I would say why delete it when you wish to recreate it? Just adjust the properties - incl. the SQL property - and you're off.
Or why create it at all? Create a temp query (use a zero length string as query Name when you create the object), use the querydef object and forget it when you are done.

/gustav

>>> bchacc at san.rr.com 08-06-2006 16:53 >>>
Jim:

That's going to be a really handy piece of code.

Would there be a downside, however, to using

On Error Resume Next
(Delete Object)
On Error GoTo 0

I've done that before but it seem s bit like working without a net. 

Rocky