This is much like my last question, I am sorry, for asking questions that I should be able to find the answers to, but I do not quite know the correct descriptors to get them.
So I have 20 variables;
dim sP1FieldName , sP2FieldName, sP3FieldName to sP20...
dim i as integer
i = 1
Do While i < 21
sCurrValue = getDateField(i)
' getDateField() is a function that gets the date for field 1 this all works correctly
' now I want to recreate the correct variable that I created above with the text
'and the i number
"sP" & str(i) & "FieldName" = sCurrValue 'This is where I am having the problem
i = i + 1
Thank you experts