Walk through table in MS Access VBA

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.