iterate through records

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

Guest

I would like to use a "For Each" statement to interate through records in a
subform. Can this be done? i.e. how do I specify the object and collection?
Thanks so much!!
 
Maybe possible for masochists. The official way is to use the subform's
RecordsetClone or Recordset property, e.g.

With Me.RecordsetClone
.MoveFirst
Do Until .EOF
'do stuff

Loop
End With
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

iterate thru group of selected records 6
Access Main form/Subform Navigation 0
Cannot iterate through the items in custom class collection (NewEnum()) 8
Webcast recording. 3
Iterate through tab pages 8
calling objects method 4
Advantages and disadvantages of individual file based compression and inter-file compression 1
Iterate through sequencial variable 6

Back
Top