I have the following comments concerning your solution:
1/ The '$' is missing on the second line
2/ The update method is missing
3/ The match statement is missing
4/ The original error does not appear - thanks, progress
I would require both the update method and match statement.
Once again I an grateful for your time and expertise.
My initial idea was to have a single function to update the fields, but I realize that this would be cumbersome with macros. I have accepted your solution as a better design.
Once again thank your for your responses. I have a long learning curve with macros, but have made a good start with this recent experience.