Mike
Use a counter in the loop and a select case
For x = 1 to 3
Select Case x
Case 1
v1 = Something
'or
Something = v1
Case 2
v2 = Something
'or
Something = v2
Case 3
v3 = Something
'or
Something = v3
End Select
Next
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, mithomas48 <no_reply@...> wrote:
>
> How can I dynamically reset a variable within a loop - without using a Select Case, or IF Else? For Example...
>
> First pass = v1
> Second pass = v2
> Third pass = v3
>
> So I need to dynamically set the last digit.
>
> Thanks in advance!
> Mike
>
Tidak ada komentar:
Posting Komentar