For each...Next statement 1

[medium]

Does anyone know if the For Each...Next statement can be used on the records that are in a query?

If so, how would one facillitate this with code?

Thanks in advance.

 

[jebry]

Hi!

If you open a query in code (I assume using a recordset) then it is most common to use a Do loop.

rst.MoveFirst
Do Until rst.EOF = True
Do your stuff
rst.MoveNext
Loop

hth
Jeff Bridgham
bridgham@purdue.edu

 

[medium]

Thank you very much.