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
 
Back
Top