extract range, create loop, pass parameter

[MDA]

Hi all,

I am trying to figure out how extract a range from two combo boxes then pass them to a stored procedure one by one..

Example:
Two combo boxes with 12 months 01 - 12. The first box is a start month and the second box is end month. If the user puts in 01 for start and 06 for end, then I want to pass 01, 02, 03, 04, 05, 06. The stored procedure will run for 01 then when it is finished, VB will pass the next parameter 02, etc, etc. I want to control this in VB and not the SP.

Any ideas on how to do this? I am thinking that after I determine the range, I can create some kind of loop?? Not sure where to start with this idea though...


Thanks for any ideas!!

Regards,
Mike

 

[sunaj]

----------------------------------------------------------
For i=val(combo1.value) to val(combo2.value)
YourSub(format(i,"00&quot)
next i
----------------------------------------------------------

Sunaj

 

[MDA]

Thanks Sunaj,

That worked like a charm!!

Regards,
Mike