Delete Query

G

gr

hi, I have a delete query which I want to call from VBA.
My question is should I use
DoCmd.OpenQuery "delqryName", acViewNormal

or I should use the DoCmd.RunSQL Method with its
corresponding sql statement.

is there any difference??

thx,
gr
 
V

Van T. Dinh

OpenQuery can be used to run action query so it is OK. Don't need
acViewNormal though as there is nothing to display.

You may like to use the Execute Method of the database object.
 
Top