Thank you for the replies, so far, but they don't resolve my problem.
This is a web-enabled database. My understanding is you cannot use VBA in this type of application. Only macros can be used.
I understand it's not good to store the same data in two different tables, and I'm trying to avoid...