Stepping through a Record set

J

Justin

I need to step through a record set too compare values. Normally I would
create a form to do this. Is there a way to do this in code only?
 
M

Marshall Barton

Justin said:
I need to step through a record set too compare values. Normally I would
create a form to do this. Is there a way to do this in code only?


rs.MoveFirst
Do Until rs.EOF
If rs!somefield = somevalue
. . .
End If
rs.MoveNext
Loop
 
Top