• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

Traversing a RecordSet in Access

Is it possible to traverse a recordset in MS Access by referrencing the first record, then using a 'Next' command Until the end of the recordset is reached?
Thanks.
0
kh5395
Asked:
kh5395
1 Solution
 
chewhoungCommented:
Try this code:
myrecordset.movefirst
with myrecordset
   do while not .eof
      ...
      .movenext
   loop
end with

0
 
kh5395Author Commented:
Sorry about the delay, have been very busy!
Tahnks for your help.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now