Thanks aytee111,
I should have phrased that better.
How would I cycle through these fields?
SINCNum1 = rU.Fields![SINCGARS 1]
SINCNum2 = rU.Fields![SINCGARS 2]
SINCNum3 = rU.Fields![SINCGARS 3]
SINCNum4 = rU.Fields![SINCGARS 4]
SINCNum5 = rU.Fields![SINCGARS 5]
SINCNum6 = rU.Fields![SINCGARS 6]
Where I could use the SINCNum1 - 6 as representing the field name?
I want to take the following:
Code:
If rU![SINCGARS 1] = "METT" then
SINC1 = "METT-T"
ElseIf rU![SINCGARS 2] = "METT" then
SINC2 = "METT-T"
ElseIf rU![SINCGARS 4] = "METT" then
SINC3 = "METT-T"
ElseIf rU![SINCGARS 4] = "METT" then
SINC4 = "METT-T"
ElseIf rU![SINCGARS 5] = "METT" then
SINC5 = "METT-T"
ElseIf rU![SINCGARS 6] = "METT" then
SINC6 = "METT-T"
End If
To Something like this:
Code:
For I = 1 to 6
SINCNum = "??????????????????????????? Where it references [SINGARS 1] to [SINGARS 6]
If SINCNum = "METT" then
SINC = "SINC" & M
For M= 1 to 6
SINC = "METT-T"
End If
Next M
Next I