I was curious as to why you favor VBA over Macros? Is there any technical reason? -Clem

---

I could probably write a LONG post about the differences, but for me it's more of a personal preference. I've been a programmer pretty much all my life, and VBA just seems more intuitive to me. VBA is more flexible. VBA is easier to work with (I think). VBA gives you much more power. The only benefit to macros is that they're more portable. You can now distribute "safe" macros in Access 2007 and 2010 that can still run (both on the desktop and the web) without setting off security warnings. Only SIMPLE commands work, but it's good for projects you want to distribute publically. -Richard