No, do not link those two tables in apdClientSearch. Those tables do not have relationship. Idea is to use a Cartesian product query so the single record in Quote will show with every row of query.
All tables are local with exception of CustomersCallCare and that db was not provided.
I tried subst.exe command and get errors in db procedure. Apparently virtual directory is not actually created.
BTW, don't use quote marks around alternate path string.
https://docs.microsoft.com/en-us/win...commands/subst
None of my attempts with this command succeeded.
Maybe there is a permissions issue.
Sorry, don't have solution other than to not rely on this substitute pathing.
I saved db to C: drive folder and modified code to reference that location. Code works.
I would eliminate as much of Word merge as possible and output Access reports instead.
Strongly recommend converting macros to VBA, one reason being VBA is easier to debug.