You should get Total Visual Code Tools one of the tools allows you to copy sql from the access query builder and it automatically makes a vba variable for you. It has a bunch of other helpful tools. well worth the price.
http://fmsinc.com/MicrosoftAccess/VBACodingTools.html