Thank you, Paul. I will go next to the Access forums as you recommend. I just figured since all of this vba code is written in a Word template in order to push the data to Access this was the place to start.

If I get an answer there, I will be sure to come back here and let everyone know since it seems to me as though the answer to this problem is going to require vba magic on both sides.

Cheers!

On an aside, how does one mark this thread as done? I don't want it to clutter up the forum.