Holy [Explicit]! I am now making some progress.. That seems to now be taking care of the syntax error message when I hard code the value for [AR Group] Now to just get it to work programatically.
THANKs so much Everyone! I'm sure I will still need some help, but let me see where I can go with this.
The difference is that there is also an ADO recordset, which has different syntax. Access didn't know which one you wanted, and made the wrong assumption (based on which was higher on the list).
Wow! Thanks again I can't believe all this because Access didn't have it's ADO Powerbar. lol. I have it sending e-mails and doing exactly what I needed it to do now..
I was about to go bonkers having 1 line of code hold up my project. hehe.