I'm thinking that a macro can resolve the path to a form on a navigation form (because you click to it) but to do this in vba requires 2 things:
- that the form to be affected is the same form as the event is on because it spite of how it looks, a nav form only loads one form at a time
- that you use Me or if not required, no form reference because the nav form adds extra layers to the reference "chain". I would not expect your form reference could be resolved when it's on a nav form. Not 100% sure because like many, I avoid nav forms and macros.
Last edited by Micron; 06-12-2019 at 01:46 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.