Stepping through a Record set

[Guest]

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?

 

[Marshall Barton]

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