You mention "macro" but show what looks like vba and they are not the same. I can find nothing in the entire list of macro command that would allow you do do this.
So if in fact this is about code, then my guess is that the field is a lookup field in your table. You should explain what is meant by not using the clicked field value. What value does it use and what value do you expect it to use.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.