I have a form with a series of common named controls that I want to update to the storerd values in similarly named public globals.
I want to set this up as a "for" loop as I have a lot of field variables and have the syntax for the form fields as:
For i = 1 To 10
Me("txtTextBox" & i).Value
How do I structure global variable?
The below is kind of what I want but obviously is incorrect syntax
Me("txtTextBox" & i).Value = pubText & i