Steve Schapel
miscellany at mvps.org
Wed Jul 4 23:59:28 CDT 2007
Sorry to be contrary, Steve, but I don't think this is supported by the evidence. In fact, I believe DoCmd.OpenQuery would perform faster if you are running a saved query, as long as the number of records hasn't changed dramatically since the last time it was run. But either way, I think this is possibly academic interest only, as the speed differences here are likely to be imperceptible. Regards Steve Steve Conklin wrote: > Replace any DoCmd.RunSQL's with CurrentDB.execute. >