I have basic understanding of how to refer to fields on a form/subform via VBA but I have come stuck with a subform which is a pivot. I use the following code:
Now, All the form names are correct and the forename field is also correct. When I run the above the good news is that it does not error, however, it always returns the forename of the first person in the list. Irrespective of what person is highlighted on the pivot subform.
This is driving me mad so any help would be greatly appreciated :)
Many thanks in advance, Alan.