FOR...NEXT all records in a table?

[timesscript]

I am still trying to figure out VBA and I need help on the syntax of a statement that will loop through each record in a table and allow me to then use the values in each field of that record to perform calculations. Can someone make a basic FOR...NEXT statement to teach me how to formulate that? The help files I am reading don't seem to show me what I'm looking for.

[ranman256]

you dont use FOR NEXT for a table...thats what a query does, and it does it much faster.
Use an update query to perform the calc and store in a field.

[pbaldy]

Completely agree that an update query would be more efficient than looping. If you need it for something else, here's my template code:

  Dim strSQL  As String
  Dim db      As DAO.Database
  Dim rs      As DAO.Recordset

  Set db = CurrentDb()
  
  strSQL = "SELECT ..."
  Set rs = db.OpenRecordset(strSQL, dbOpenDynaset)

  Do While Not rs.EOF

    rs.MoveNext
  Loop

  set rs = nothing
  set db = nothing