Greetings,
Thank you both for your quick responses.
tfurnivall to answer your question about the docmd, I created the macro in the access gui first then transfered the code to VBA, which might be why it looks odd, but it works, which at this point is what I need.
I have read over your...