This is simple but a little tricky to explain.
1. Run FORM1
2. Change the MyName field from "Pete" to "Joe" (or similar).
3. Use the record selector to go to the next record.
4. System will STOP
5. A FUNCTION had been called which will write before/after values of each control passed.
6. Note that the before and after values are displayed in the immediate window.
7. So far , so good.
Question: How do I also Debug.print the variable name. I.e. I also want to see the words "MyName" in the immediate window. (And all the other field names as they loop)
This is a slightly odd question.
In other words I know the current (and old) value of a field... being "Joe" and "Pete" (or whatever).
However, I do NOT know the field name.