Delete Query

  • Thread starter Thread starter gr
  • Start date Start date
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
 
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.
 
Back
Top