How to loop through each record in table

[behnam]

Hi all,



I have a code to do things to a record but i want to perform that on every record in a table. Can someone help me with the vba to loop through every record in a table (tablename:Assets).

thanks.

[ItsMe]

Maybe some DAO

Dim oRS As DAO.Recordset

Set oRS = CurrentDb.OpenRecordset("Assets", dbOpenDynaset)
oRS.Movefirst

while oRS.eof = false

'Do Something

oRS.MoveNext
wend

oRS.close
set oRS = nothing

[orange]

Here's a link that will help you.