Loop through all record in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

How can I loop through every record in a table and edit the value of each. I tried the code below but I can't get it to work

Set rs = Me.Recordset.Clon
rs.MoveFirs
Do While Not EO
With r
Me.Bookmark = rs.Bookmar
.Edi
.Fields("Include In Report") =Tru
.Updat
End Wit
rs.MoveNex
Loo

Daniel
 
Do While Not rs.EOF

--
Patricia Cardoza
Outlook MVP
www.cardozasolutions.com

Author, Special Edition Using Microsoft Outlook 2003

***Please post all replies to the newsgroups***
Daniel P said:
Hello,

How can I loop through every record in a table and edit the value of each.
I tried the code below but I can't get it to work.
 
Back
Top