Discussion Locked

Walk through table in MS Access VBA

0 helpful

3 replies

by hlc Jan 6, 2003 last reply Jan 6, 2003

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to walk through the rows of a table and test each in a Select Case. I have looked at For Each but can't determine what the syntax would be.

I don't really write in VBA anymore and I'm stumped.

Thanks.

3 replies

Don't use a For Each, open a recordset on your table and loop through it:

Do Until myRecordset.EOF
(your Select Case here)
Loop

Glen

Thank you.

This question was closed by the author

This discussion is closed to new replies.