Solved: Looping through a table

[MWE]

Try something like this.

[vba]

Set db = CurrentDb

Set rst = db.OpenRecordSet("A")

rst.MoveFirst

While Not(rst.EOF)

Msbox rst.Fields("A2").Value

rst.MoveNext

Wend[/vba]

Thanks. This works.

Now to do it the way I ultimately need to, .MoveFirst and .MoveNext can not be used except for the first pass. This is handling the table like a roll of mag tape. I need to be able to index directly to specific records. So:

1. What Type is rst in the above example? Seems to me that it should be of type RecordSet (and that agrees with the object browser), and rst.RecordCount does give me a correct record count. But if I Dim rst as RecordSet, the statement

Set rst = db.OpenRecordset("Books")

fails. ("A" = "Books")

2. How do I refer to record "i"

Thanks again.