Queries vs VBA DoCmd.RunSQL

[ck4794]

So as I'm coming on board with using VBA as opposed to MACROS, I'm also discovering how to write SQL. So here's my question:



Is there an advantage to creating a query instead of using DoCmd.RunSQL in a VBA module?

I've managed to replace all my append, delete, and lookup queries. The only advantage I see so far, is on an action query, the option to see what results are going to be returned before actually running it. That and SQL view when I get confused on the language I need to use.

Anybody Else want to weigh in on the subject?

[RuralGuy]

Static queries have a strategy built into them where dynamic queries need to develop that strategy before they run. This makes Static queries just a little bit faster along with the issues you already discovered.