Hi Andy,
Since your request is more related to macro, I'll move it to Access for Developer forum:
https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
Regards,
Steve Fan
Please remember to mark the replies as answers if they helped.
If you have feedback for TechNet Subscriber Support, contact
tnmff@microsoft.com.