refer to variables in loops

[autex]

I'm trying to be more efficient with my code. I've got 6 variables c1, c2, ...., c6 I want to refer to the value of these variables in a loop. This is my loop:

For s = 1 To 6
c = "c" & s
If c <> "" Then
SendKeys c & "{enter}"
End If
Next s

I'm getting this
c1
c2
c3
c4
c5
c6

I want to get the values of c1, c2 etc.

Any advice?

 

[PHV]

Why not simply using an array ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[denosaur]

autex,

How are the values of the variables stored? If I knew more, I might be able to help.

 

[autex]

I've never used arrays, I'll check them out thanks.

How are the variables stored?
the variables are values from the forms and subforms


c1 = Nz(me.textbox, "")
c2= nz(me.adifferenttextbox,"")
etc.



Me.Text0.SetFocus

For s = 1 To 6
c = "c" & s
If c <> "" Then
SendKeys c & "{enter}"
End If
Next s

 

[autex]

I like arrays, thanks for the suggestion. I still need help knowing what I don't know. I'll scratch arrays off the don'tknow list.