Thanks Bill, but I'm trying to stay away from using a Select Case or If Else. Isn't there a simple function or something that can dynamically change a variable? For example...
In each pass the variable "b" would become b0, then the next pass b1 and so on.
Thanks again!
Mike
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> 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