Loop through recordset

[sabavno]

Hi

I do the following to get my recordset:


get_rollups = "select transit_no from transits where sequence > " & intSqnce &_
&quot; and sequence <= &quot; & intBottom & &quot; and Rec_month = &quot; & RecMonth &_
&quot; and Rec_year = &quot; & RecYear & &quot; and Hi_level = &quot; & intLevel + 1

Set rs1 = dbtransits.execute(get_rollups)


Then I want to call another function and pass the value of transit_no from rs1 recordset.

How do I loop through rs1 to assign each transit_no to the variable and then pass that variable to the next function?

The logic is:

Do Until rs1.eof
param=rs1!Transit_No
call NextFunction()
rs1.movenext
Loop

What is the syntax?

Thanks

 

[GaryC123]

param=rs1!Transit_No
should be written like this
param=rs1(&quot;Transit_No&quot Saturday 12.00

20.00

3.00am

Sunday [img http